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

trouble with (complicated) vlookup searching another workbook 2
Adding data to MS Access from csv file 0
Source information from different sheets with vlookup 0
Multiply with Vlookup value from another Worksheet 0
Hlookup/Vlookup with duplicate datas 0
Vlookup from different sheets 2
VLOOKUP duplicate values in table the table array? Help me solve 1
Adding VLOOKUPS across multiple worksheets 3

Top