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