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

Question

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 

System Configuration: Windows / Chrome 57.0.2987.133

vcoolio · Answer

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.

Automatically copy contents from multiple shts to a summary sht.

1 response

Similar discussions

Subscribe To Our Newsletter!