Automatically copy contents from multiple shts to a summary sht.
Closed
Harris
-
Updated on Apr 5, 2017 at 02:49 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Apr 5, 2017 at 02:58 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Apr 5, 2017 at 02:58 AM
Related:
- Automatically copy contents from multiple shts to a summary sht.
- Transfer data from one excel worksheet to another automatically - Guide
- Summary slide powerpoint - Guide
- How to delete multiple files at once - Guide
- Allow multiple downloads chrome - Guide
- Pc restarts automatically - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Apr 5, 2017 at 02:58 AM
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.