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

Here is the situation - I have a workbook with lots of different
worksheets. All of the sheets have the same columns. What I want to do
is whenever I add an entry into one of the worksheets that entry
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 the
data was entered onto those sheets.

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


--
tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access

Hi Tony

If I understand you correct you can use something like this
http://www.rondebruin.nl/copy2.htm





--
Regards Ron de Bruin
http://www.rondebruin.nl


"tonyDeBrasco" <tonyDeBrasco.1sj0ny@ wrote in message ...

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

Here is the situation - I have a workbook with lots of different
worksheets. All of the sheets have the same columns. What I want to do
is whenever I add an entry into one of the worksheets that entry
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 the
data was entered onto those sheets.

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


--
tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access

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

So I think the total problem is:

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


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

Many thanks
Tony


--
tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access

Hi Tony

Try this
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"tonyDeBrasco" <tonyDeBrasco.1ske3y@ wrote in message ...

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

So I think the total problem is:

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


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

Many thanks
Tony


--
tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access