how do i link data from closed worksheets without vlookup.

R

Rainmaker

Dear Friends,
In my line of work, i have to get data from 2500(variable huge number)
sheets on to a single sheet.
The name of the sheets are formula based, and formatted the same way(auto
generated), and so its easy for me to create a direct link to the cells via
formula.But it creates the problem that formula won't update(press f2 and
then 'enter'). I cannot open so many files for the formula to update(so i
can't use Indirect). I cannot use vlookup.

kindly help. all the usual stuff i read was for getting too much data from
limited sources. Here the issue is that i have to get little data from too
many sources.

HELP!
(i also can't write VB codes)
 

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

Need VLOOKUP to Work Two Ways 0
Vlookup from different sheets 2
Vlookup and return sheet name also 2
vlookup formatting problem 1
Vlookup across 3 worksheets 2
VLOOKUP help needed.!! 3
First column of range in VLOOKUP contains formula 2
Adding VLOOKUPS across multiple worksheets 3

Top