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!
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variations on referencing a cell in another workbook - continued 4
variations on referencing a cell in another workbook 2
How do i copy a cell from a workbook to another workbook? 7
Macro to open file and copy information from worksheet 1
Copy cell to another workbook 1
How to create a fill down that increments based on the workbook name 4
how do i copy a worksheet to another work book 1
Copy range from one workbook to another 6

Top