auto cut and paste...
hi guys , this is my problem: i got 5 worksheets in a workbook and now i am creating another worksheet that is the summary of all the 5 worksheets.The 5 worksheets are named 1-5 and the formats are the same. Now, instead of transfering the data from each sheet and do a "cut and paste" job i was thinking if the datas in worksheets 1-5 can be automatically transfered to "summary" based on the last entry of each sheet. pls advise..... -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=479665 |
auto cut and paste...
Don't use it based on your last entry. Instead, put your totals in Row 1:
something like =Sum(A3:A65536) will get you the sum no matter how many rows you have. Then, use this: http://www.officearticles.com/excel/...rk sheets.htm or just copy Row 1 from each workbook to your summary sheet and Edit--Paste special--Paste link ************ Anne Troy www.OfficeArticles.com "cjjoo" wrote in message ... hi guys , this is my problem: i got 5 worksheets in a workbook and now i am creating another worksheet that is the summary of all the 5 worksheets.The 5 worksheets are named 1-5 and the formats are the same. Now, instead of transfering the data from each sheet and do a "cut and paste" job i was thinking if the datas in worksheets 1-5 can be automatically transfered to "summary" based on the last entry of each sheet. pls advise..... -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=479665 |
All times are GMT +1. The time now is 01:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com