Transferring date from multiple worksheets to a "totals" worksheet.

T

tonyDeBrasco

Hi, would be most appreciative if someone has a solution to this. As
am new to Excel I don't know if it is possible to do but hopefully i
is.

Here is the situation - I have a workbook with lots of differen
worksheets. All of the sheets have the same columns. What I want to d
is whenever I add an entry into one of the worksheets that entr
automatically gets added onto the end of the totals worksheet.

eg

Sheet One
Property Date Price
X dd-mm-yy 123,456
Y dd-mm-yy 456,789

Sheet Two
Property Date Price
a dd-mm-yy 444,555
b dd-mm-yy 789.654

Totals
Property Date Price

=> Should contain data from sheet one and two in whatever order th
data was entered onto those sheets.

I hope the problem is clear and someone has a solution.
Many thanks,
Ton
 
T

tonyDeBrasco

Many thanks for the help, it worked a treat alas no the bar has risen
smidgen. Now I have to try and somehow grab a few sheets (all with th
title totals) from different workbooks and from those different sheet
generate an overall totals sheet. The columns on the individual total
sheets are all the same.

So I think the total problem is:

- somehow allowing the user to indicate what workbooks they want t
grab the totals sheets from
- taking all the data off these total sheets and then creating a
"ultimateTotals" sheet...


If anybody has any ideas or suggestions as to how this could be don
(if it can be done) twould be great,

Many thanks
Ton
 
Top