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

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


Please help!

I do my best to keep all my data in one worksheet. Then I can use
data|filter|autofilter to show just the information that I want (filter to show
what ever voucher number you wanted to see).

If that doesn't work for you, then I'd still keep all my data in one worksheet
(easy for updating) and generate new worksheets whenever I updated the master
worksheet.

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Savage wrote:

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

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

Please help!

--

Dave Peterson