Copy query from all worksheets of same workbook

Closed
aj - Nov 27, 2016 at 04:50 PM
yg_be Posts 22711 Registration date Sunday June 8, 2008 Status Contributor Last seen April 21, 2024 - Nov 28, 2016 at 03:09 AM
Hello,

Please help me with below,
I have 600 worksheets file, out of which i want to add only fiest column of all sheets in one master file and then needs to come up with which are comman sheets.
Only heading name is different and needs to match rest of the column data.

Thanks,

1 response

yg_be Posts 22711 Registration date Sunday June 8, 2008 Status Contributor Last seen April 21, 2024 5
Nov 28, 2016 at 03:09 AM
I understand this :
- for each worksheet from each (600) workbook, you want to copy the first column into a master worksheet in a master workbook.
Is that correct?
Do you have a list of all workbooks, or a way to find them?
Do you want to transfer each column into a single column, or each into a seperate column?
What do you want about "heading names"?
What do you mean with "needs to come up with which are comman sheets"?
0