Related:
- Copy query from all worksheets of same workbook
- Vba copy data from one workbook to another - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Worksheets add vba - Guide
- Run macro when workbook opens - Guide
- You have a workbook with multiple worksheets and want an exact copy of one of the worksheets ✓ - Excel Forum
1 response
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"?
