Copy query from all worksheets of same workbook
Closed
aj
-
Nov 27, 2016 at 04:50 PM
yg_be Posts 23258 Registration date Sunday June 8, 2008 Status Contributor Last seen October 15, 2024 - Nov 28, 2016 at 03:09 AM
yg_be Posts 23258 Registration date Sunday June 8, 2008 Status Contributor Last seen October 15, 2024 - Nov 28, 2016 at 03:09 AM
Related:
- Copy query from all worksheets of same workbook
- Transfer data from one excel worksheet to another automatically - Guide
- Vba copy data from one workbook to another - Guide
- How to avoid duplicate records in sql select query - Guide
- Run macro on opening workbook - Guide
- How to automatically transfer data between sheets in Excel - Guide
1 response
yg_be
Posts
23258
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
October 15, 2024
5
Nov 28, 2016 at 03:09 AM
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"?
- 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"?
