Copy query from all worksheets of same workbook
Closed
aj
-
Nov 27, 2016 at 04:50 PM
yg_be Posts 22692 Registration date Sunday June 8, 2008 Status Contributor Last seen April 16, 2024 - Nov 28, 2016 at 03:09 AM
yg_be Posts 22692 Registration date Sunday June 8, 2008 Status Contributor Last seen April 16, 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
- How to avoid duplicate records in sql select query - Guide
- To copy a worksheet from one workbook to another, begin by opening - Excel Forum
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Excel vba copy worksheet to another workbook without opening ✓ - Excel Forum
1 response
yg_be
Posts
22692
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 16, 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"?
