|
Transferring date 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 -- 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 |
| All times are GMT +1. The time now is 05:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com