I am wondering how to create a macro that could batch find and replace based upon cell values in column A1-A10 - Sheet1. Then save each worksheet (except Sheet1) out as a text file.
Within the workbook, I have Sheet1 which has the values
For Example
A1 = County 1
A2 = County 2
A3 = County 3
etc... to
A10
Within the worksheets the keyword i want to replace is "County".
Sheet2 - County Parcels
(Random cells have "County" I would like to replace with Count 1 or Sheet1 A1.[if it can replace the sheet2 name too])
Then save this worksheet out as a text file.
Go to the next Sheet3 and do the same functions as above.
Does this make sense for excel to help do something like this?
Thanks for any guidance.
Within the workbook, I have Sheet1 which has the values
For Example
A1 = County 1
A2 = County 2
A3 = County 3
etc... to
A10
Within the worksheets the keyword i want to replace is "County".
Sheet2 - County Parcels
(Random cells have "County" I would like to replace with Count 1 or Sheet1 A1.[if it can replace the sheet2 name too])
Then save this worksheet out as a text file.
Go to the next Sheet3 and do the same functions as above.
Does this make sense for excel to help do something like this?
Thanks for any guidance.
