hello everybody
I have a worksheet that has a header in cell A3 "Code" in cell B3 "Description" and in cell C3 "Base Rate".
There is the possibility of creating a code to verify other workbooks open and search the headers and copy the data below the header to my worksheet?
Note that the column match may not be in proper order.
For example in my Worksheet cell A3 "code" on the workbook may be in cell H1 or another column.
Thanks in advance