Hello,
Current Scenario :
I have a Macro File which goes to a defined folder. Into that folder there are multiple excel workbooks
Into Macro file, I've manually added some of the columns which are almost common in every workbooks
This Macro goes to each workbook, copies the data to my Master file in transpose format (see attached output file)
Into this Macro file, there is a Hidden sheet, into which I've added the column names and their content (see below e.g.)
Vegetable white gourd
Vegetable Ribbed gourd
Vegetable Snake beans
Vegetable Curry leaves
Vegetable Bitter melon
Vegetable Okra
Country United States
Country United Kingdom
Country India
Country Mexico
Country Canada
As in this example, we see there are Fruits, Vegetable and Country name
Into Output file, data for the above column content has got updated after running the Macro
But, in one of the Workbook, there is also an additional column content named as "City"
As we have not updated this column content to the Master File manually, so I want the macro to automatically detect the column which is not in the master file and automatically update the same at the end i.e. Q1 (see Output File)
Apart from Fruits, Vegetable and Country, if there are any new columns found into the source file, that should get added to the Macro file, as per standard in Output file
The 1st source file was containing only Fruits, Vegetable and Country column, so the data has got updated in Row 3.
In 2nd source file, there are also the above same column content, but there is additional one more column content i.e. "City".
So the Macro should updated the data as per data shown in Row4 (Output file)
Thanks,
Bookmarks