Automatically copy contents from multiple shts to a summary sht.
Closed
Harris
-
Updated on Apr 5, 2017 at 02:49 AM
vcoolio
vcoolio
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Related:
- Automatically copy contents from multiple shts to a summary sht.
- This site attempted to download multiple files automatically - Guide
- Macro to automatically update a master sheet from multiple sheets ✓ - Forum - Excel
- Transfer data from one excel worksheet to another automatically - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
- Pc restarts automatically - Guide
1 reply
vcoolio
Apr 5, 2017 at 02:58 AM
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Apr 5, 2017 at 02:58 AM
Hello Harris,
Which column are you using as the "key"? That is, in which column will your last entry be made and will this column have a specific criteria (such as "Yes" or "Completed" or "Done and Dusted" etc.) to initiate the code?
It would be best if you could upload a sample of your work book ( just a few rows from each sheet --->just a few sheets not all fifty) to a free file sharing site such as Sendspace, ge.tt or DropBox and then post the link to your file back here. Please use dummy data.
We will then have a better understanding of your query.
Cheerio,
vcoolio.
Which column are you using as the "key"? That is, in which column will your last entry be made and will this column have a specific criteria (such as "Yes" or "Completed" or "Done and Dusted" etc.) to initiate the code?
It would be best if you could upload a sample of your work book ( just a few rows from each sheet --->just a few sheets not all fifty) to a free file sharing site such as Sendspace, ge.tt or DropBox and then post the link to your file back here. Please use dummy data.
We will then have a better understanding of your query.
Cheerio,
vcoolio.