i have to link the data from another workbook containing multiple worksheet
having same sort of data for individual companies, and have to link the data
in another workbook and want that a formula should find the required
worksheet first and then apply the Vlookup formula. the lookup cell value and
the worksheet names in other workbook are the same.
it can be done easliy if i assign worksheets manually in every formula but
it will not help me and required to do alot more manuall in everyday routine
for any modification or addition.
I am using the Microsoft Excel 2003.
If anyone can help please