Automatically copy contents from multiple shts to a summary sht. [Closed]

Report
-
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
-
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

Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
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.