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.
Automatically copy contents from multiple shts to a summary sht.
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.