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

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