Search multiple workbook headers and copy column entries to another workbook
Hi guys,
I've been trying to find something that will help me with this but haven't found anything I can manipulate to suit my needs.
My problem is this:
I have many workbooks in a folder, lets say c:\temp\book1.xls, book2.xls...book100.xls
I have another workbook in c:\main.xls
Each of the workbooks in c:\temp contain different columns in different orders, but they all have one consistant column header labelled 'Phase' in the first row (the column number is not the same however).
main.xls also has a column labelled 'Phase'.
Also the column may occur more than once in a workbook.
What I'm looking for is a macro that I can run from main.xls, that will look through all of the workbooks in c:\temp, search the top row until it finds 'Phase' and copy all of the non blank entries in that column, and put them into the 'Phase' column in main.xls, one after another (essentially making one big list of all the phases from the workbooks in c:\temp.
Additionally, if possible, i would like it to put the name of the workbook it found the entries in next to it.
For example, main.xls would ideally look like this:
Re: Search multiple workbook headers and copy column entries to another workbook
That's fantastic! Thanks!
Theres one issue though. It copies all of the data across to the main spreadsheet, but it overwrites itself rather than listing down the columns?
Re: Search multiple workbook headers and copy column entries to another workbook
hi
it should copy the contents of each cell below a heading "Phase" to a new row in the master sheet - this bit of code should add 1 to the destination row each time a new phase is copied:
PhaseLast = PhaseLast + 1
or is the problem with the workbook? if you want the contents of the cell to read
Bookmarks