Finding data in another workbook, possible?

[Nishikawa]

Hi,

I am trying to create a master file that goes into ddifferent workbook to extract data.

E.g, I would like VBA to go into Timetable(workbook), into classA(worksheet) in week 32(Column) and Maths(Row) and extract the data in that particular cell.

If this possible? Please help.

 

[namliam]

yes it is, if you simply open both sheets and build any formula you want like vlookup or something using the wizard, you can use "window" from the menu to navigate to another workbook and fetch data there.

No problem what so ever.

 

[Nishikawa]

I would like it to search for the cell without opening the other file. Something like "update information"
Reason is because this master file needs to be linked to more than 10 other files.

 

[namliam]

You only need to create said link once... or create one to a dummy file.
Then you can see how the link works and addapt for your 'real' use.