Now I'm working on a macro to find and replace column headers in a
spreadsheet that the raw data I use in XL comes from. I've only got a
week left on my contract with the state which may be enough time to get
another set of data out to the counties. (Have applied for a full time
job here, so I might be back.)
I have 2 columns of data, starting at B40, in one workbook, call it
ABC. Column B contains the Source document headers I want to replace in
the other workbook, and Column C has the headers I want to replace them
with. I want to select the downloaded data worksheet, then run the
macro to go the the other workbook, get the old header in cell B40, try
to find it in row 1 in the downloaded datasheet and replace it with the
text in C40. Then go to B41, and repeat the procedure until it hits a
blank cell in column B. If it fails to find the text from column B,
just continue with the next cell in the column.
This will make reformatting the incoming datasheets much quicker, so I
can then copy them into the existing workbook with the new quarter's
data.
Can anyone point me in the right direction as to how to set this up? I
appreciate the help.