Automatically copy contents from multiple shts to a summary sht.

Closed
Harris - Updated on Apr 5, 2017 at 02:49 AM
vcoolio
Posts
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
- Apr 5, 2017 at 02:58 AM
Hello,

I've an appointment sheet for each client of mine with their details. lets say like 50 sheets. I'd like to create a summary sheet from all these 50 sheets. I do not wish to have all the data from these sheets. I just want to automatically copy or insert certain rows to my summary sheet. I am saying auto because I want to type in a certain sheet and it automatically copy into my summary sheet.

I can't put my brain at work so need your help.

Thanks, Harris

1 reply

vcoolio
Posts
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
249
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.
0