Copying Data from Multiple Sheets to One sheet

M

MAB

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

have one sheet update others in workbook 1
Transferring data from multiple sheets in workbook to one sheet 5
collecting fata from all sheets into one sheet 4
Update multiple sheets 1
Excel, assign cells in multiple worksheets from one sheet 1
Data Validation 1
Pivot Table using data from multiple sheets 1
Auto update worksheets 2

Top