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