how to copy the same cell across different work books into another workbook easily?

S

sageerai

i have the daily sales from 1.xls, 2.xls likewise till 31.xls, in a
single folder. now i have a final consolidated workbook called
final.xls, wherein i would want to copy the same cell across all the
workbooks into final.xls(which is again in the same folder)
easily,..someway like the fill handle or is there someother way, other
than selecting each time the cell to be linked??? can anyone help, this
is really breaking my head,,....
 
R

RagDyer

When you say "Copy the same cell",
Do you perhaps really mean "total"?

If so, try this:

=SUM(Sheet1:Sheet31!Z100)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top