Hello,
I have several workbooks containing one sheet each with a database (each line corresponds to a day, each column to a parameter).
I'd like to standardize the headers text so all workbooks (all databases) will have the same header for a same parameter. Right now, I've often slightly different names for a same parameter (for example: "Resistance" in workbook A, "Res." in workbook B, but both are the same parameter).
I've created a list containing the existing values of all headers from all workbooks. I've placed this list in column "A". On the adjascent column "B", I wrote how I want that header to be called through all workbooks (replacing the original value).
Could you help me with a macro that finds the value in "A" and replace it using the value in "B" through all workbooks?
Thank you very much!
Kevin
I have several workbooks containing one sheet each with a database (each line corresponds to a day, each column to a parameter).
I'd like to standardize the headers text so all workbooks (all databases) will have the same header for a same parameter. Right now, I've often slightly different names for a same parameter (for example: "Resistance" in workbook A, "Res." in workbook B, but both are the same parameter).
I've created a list containing the existing values of all headers from all workbooks. I've placed this list in column "A". On the adjascent column "B", I wrote how I want that header to be called through all workbooks (replacing the original value).
Could you help me with a macro that finds the value in "A" and replace it using the value in "B" through all workbooks?
Thank you very much!
Kevin
