auto cut and paste...

[cjjoo]

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.....

 

[Anne Troy]

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/sum_the_same_cell_in_multiple_microsoft_excel_worksheets.htm
or just copy Row 1 from each workbook to your summary sheet and Edit-->Paste
special-->Paste link
************
Anne Troy
www.OfficeArticles.com