Hi Luckyros,

Are all the workbooks in the same folder (directory).
Do all the workbooks share a similar filename so that part of the name and a
wildcard can be used to find them? Like MyFileName*.xls. If so, what is the
filename to use?

Please answer the above then you can help some more by recording a macro.
This is the best way of telling us what you want to do.
Open the master file.
Turn on macro recorder.
Open one of the files.
Select the required worksheet. (If already selected, select another
worksheet and re-select the required worksheet.)
Select the cell for the Vlookup formula.
Insert the Vlookup Formula (and copy it down if necessary.)
Save the workbook.
Stop macro recorder and then copy and post the recorded macro.

If you want the formula copied down to other cells then need to know if all
workbooks have the same number of rows. If not, then nominate a column that
will always have data in the last row.


--
Regards,

OssieMac


"luckyros" wrote:


I want to open multiple workbooks one by one which are in a folder on my
pc and then do vlookup based on the master file which is aready kept
open by me.there are around 700 workbooks, so opening each one by one
and doing Vlookup is a tedious task. Can anyone provide a solution macro
for this wherein all the files get open automatically one by one and
vlookup is done on them ??? after its done the file must be saved a nd
closed automatically.


--
luckyros
------------------------------------------------------------------------
luckyros's Profile: http://www.thecodecage.com/forumz/member.php?userid=337
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98732