I am new to macros. My requirement is as follows. I have bunch of excels(2007 version) in a folder. Each excel may have one sheet. Each sheet contains a set of columns. Identify the column name in the Header row and copy the entire column in a separate sheet. Like this i have 6 columns that i need to identify and copy into them all in a separate sheet. Like this accumulate all the excels in that folder. column names may not be in the same order. Hence need to find a column based on the name given by business and copy only that column and append to result in a separate sheet. I wrote some, but stuck in the middle. Kindly help me if there is a way to move forward.
Here is my program, still not complete. My idea is, 1). First iterate the folder and take each excel on sheet1. 2). Create a temporary workbook with sheet1 for appending columns here. 3.) Open each workbook and iterate header in sheet1. Once my column name matches, i want to take the entire column and append the column in that workbook in sheet1. 4.) After all workbooks are processed, save and close the workbooks.
Bookmarks