- Joined
- Jul 21, 2005
- Messages
- 13
- Reaction score
- 0
Transferring data from multiple worksheets to a "totals" worksheet.
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
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
Last edited: