Auto copying from one worksheet to another in same work book

**LiamSutherland** · 02-02-2010, 10:04 AM

Hi Folks,

My apologies if this thread has been done already but I'm new here and need help!

I have a Workbook that records incoming documents to our office on a monthly basis. At the end of the year, all of this information is copied to a new worksheet labeled "All" and acts as a summary for quick searching (I know that sounds like a gross duplication of work but it's how my supervisor wants to do things).

Is it possible to set up a function or macro that will auto populate the "All" worksheet from new information entered into another worksheet to save having to copy twelve months worth of incoming documents manually?

I've attached a working copy of the master spreadsheet so you can see what I'm dealing with.

Thanks very much.

**vikas.bhandari** · 02-02-2010, 10:54 AM

Hi there!

Please find attached the workbook. It should solve your purpose. Anyways, you will need to go to "All" tab and then click on Show Form button at the top.

HTH,
Vikas

**LiamSutherland** · 02-02-2010, 11:34 AM

Many thanks Vikas, that's exactly what I was looking for.

Is there a way of editing the code so that amendments to the source worksheets will reflect on the summary sheet without having to run the form again?

Cheers

**vikas.bhandari** · 02-03-2010, 03:02 AM

Yes, you can write the code in Sheet Change Event in the sheet Module. But please be aware that sometimes changing too many cells at one go may hang your workbook. The ideal process is to always force a macro to run rather than running it automatically. It is completely my opinion, Forum Gurus may want to add something to it

Thx,
Vikas