Copying Data from Multiple Sheets to One sheet
 

I have an Excel 2003 workbook with multiple sheets (6). The €œmain€� sheet is
where I want to include all the data from the other five sheets.
Essentially, these sheets are accounting ledgers: Column headings such as
date, acct. number, name, amount, etc.

Can I set up the main sheet where any entry I make on one of the other five
sheets will automatically copy over to the main worksheet?

Thanks in advance.

Copying Data from Multiple Sheets to One sheet
 

Take a look at this web site:
http://www.rondebruin.nl/copy2.htm

I think you can learn pretty much everything you need to learn about
copying/pasting/merging from Ron's site.


Regards,
Ryan--


--
RyGuy


"MAB" wrote:

I have an Excel 2003 workbook with multiple sheets (6). The €œmain€� sheet is
where I want to include all the data from the other five sheets.
Essentially, these sheets are accounting ledgers: Column headings such as
date, acct. number, name, amount, etc.

Can I set up the main sheet where any entry I make on one of the other five
sheets will automatically copy over to the main worksheet?

Thanks in advance.