×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Picking Data from different Data Sheets

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?

RE: Picking Data from different Data Sheets

Yes.

RE: Picking Data from different Data Sheets

(OP)
Next question..(obvious)!! How? If you the Macro code, do post it, and I will suitably customize it. Thanx.

RE: Picking Data from different Data Sheets

That would be highly dependent upon the structure and arrangement of the various files.

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

(OP)
I was thinking of simple Vlookup, with the path of the file for search purpose..but I was not succesful...the layout is consistent, but unortunately because of insertion of rows, the cell nos may not be identical for the same piece of info..say speed/HPrating/No of poles etc....

RE: Picking Data from different Data Sheets

Since you mentionded Vlookup, I'm guessing you are using Excel for this. My opinion is that spreadsheets are not meant for data storage - databases are. This task would have been trivial in a relational database. I think you should consider migrating your data sheet information into a database.

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

(OP)
Hi Xnuke..I agree with you..but there are some restrictions in the ways that we employ methods is a normal EPC project..Our motor data sheets are all in Excel. Each one has a seperate document number which is closely linked with the motor Tag no. If anybody can help in getting Vlookup working with range reference containing the path of the file, it will be awesome.!

RE: Picking Data from different Data Sheets

Parse out, build up, or use a lookup to get the file name for the motor of interest.

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()

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources