Picking Data from different Data Sheets
Picking Data from different Data Sheets
(OP)
I have a Data sheet for each LV motor, with various data viz. HP, No of poles, FLA etc.
Now, I want to populate a single worksheet with this data against the motor Tag. Is it possible to pick up the data from multiple Data sheets, located in the same folder?
Now, I want to populate a single worksheet with this data against the motor Tag. Is it possible to pick up the data from multiple Data sheets, located in the same folder?





RE: Picking Data from different Data Sheets
RE: Picking Data from different Data Sheets
RE: Picking Data from different Data Sheets
If, by chance the individual motor file names contain the "tag", or a logical relation to the "tag" you could probably do it with native functions.
If not, are all the files consistent in their layout?
RE: Picking Data from different Data Sheets
RE: Picking Data from different Data Sheets
xnuke
"Live and act within the limit of your knowledge and keep expanding it to the limit of your life." Ayn Rand, Atlas Shrugged.
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Picking Data from different Data Sheets
RE: Picking Data from different Data Sheets
Use that string in the INDIRECT() function to build the path to the file and a range within the file and plunk that all inside a VLOOKUP()