russell_chance
asked on
Automate Excel value change
I have about 1000 spread sheets that i need to change a value in. I need to find a value in cell A (for example lets say cell A12) and replace the value in cell C12. Cell A is an item number and cell C is the price. So basically I need to change the price of item number xxxxxxxx, in 1000 spreadsheets. Would a VBA script be the most logical solution to make this change on all the worksheets? Can anyone give me some suggestions on how to create a VBA script that will accomplish this task?
ASKER
We have a different spreadsheet for each different standard. The value is not difficult to locate because each spreadsheet is only 47 lines long. Find and Replace wouldn't serve much purpose. It would take an exhorbitant amout of time to chagne them all manually and other values may need to be changed in the future.
Post a workbook.
ASKER
ASKER
In the example I posted, lets say I want the OPG to be 1.2760 (cell D12) instead of 1.9430. Cell D12 is related to cell A12. Everywhere the item number of 00550014 is located, the OPG on the same row should be change to the new value of 1.2760.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Does this mean I get my points back?
ASKER
Someone from another website (excelforum.com) created this code for me. I tested it out and it works.
You could do Find and Replace, though no doubt would take some time.