Extracting rows from worksheets to make a totals sheet

S

Savage

I have multiple worksheets and any time something is entered on one of them I
want it to show up on my totals page. As an example we have mulitple sheets
with the headings. They must be all in separate sheets and can not be
combined into one.

First sheet

[Voucher Number] [Branch] [Invoice] [Customer]
12344 Fred 12345 Frank

Second sheet

[Voucher Number] [Branch] [Invoice] [Customer]
2222 Sussex 0003 Sam


Totals Sheet
[Voucher Number] [Branch] [Invoice] [Customer]
12344 Fred 12345 Frank
2222 Sussex 0003 Sam
 

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

Making a totals Sheet 1
Extracting Rows to Make A Totals Sheet 5
populate new "log" worksheet from invoice templates in other sheets 0
Mass move data in rows to columns. 3
extract data from multple worksheets to a summary worksheet 1
VBA Copy multiple columns with the same heading from one sheet to another 0
Cumulatively list data from each new worksheet 1
Pick Price From Contract Info 5

Top