So I have two spreadsheets. Spreadsheet one is a bunch of data on about 3,300 companies. Spreadsheet two lists the HR Executives for about half those companies. Is there a way to get the information on spreadsheet two in the appropriate cells on spreadsheet one? I can't just copy and paste it because the information in the rows in spreadsheet two is ordered differently from the ones in spreadsheet one.
What I'm asking is if there's a way to move an entire column into another spreadsheet, but have the rows reorganize to match the order of the other spreadsheet.
jalexanderalis,
Welcome to the Excel Forum.
To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.
The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.
To attach your workbook, click on the New Post button, then scroll down and click on the Go Advanced button, then scroll down and click on the
Manage Attachments button.
Have a great day,
Stan
stanleydgromjr
Windows Vista Business, Excel 2003 and 2007
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Spreadsheet 1 is the main data.
Spreadsheet 2 is the data I need to put in the main one. Some companies don't list HR execs, and because of the way the database I'm using creates spreadsheets, it just doesn't list the companies that don't have HR executives if I do an HR search. (I.e. I can't get it to build a spreadsheet that includes all the companies without HR execs)
Spreadsheet 3 is what I need Spreadsheet 1 to look like after the data from 2 is integrated.
Sorry to bump this, but I really need to know if it's possible to consolidate data like this. Any tips would be much appreciated.
In Spreadsheet1 E4 dragged down
=IFERROR(VLOOKUP(A4,[Spreadsheet2.xlsx]Sheet1!$A$2:$B$4,2,FALSE),"Not Found")
Does that work for you?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
It did for one cell (E4). I might not be inserting the formula correctly though. Gimme a minute. Thanks for answering though!
No, I've selected the whole column and it only changes E4 cell.
See attached.
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
....that's priceless. How select the whole column so that the formula would change for each new cell (E4, E5, E6, etc.)? I obviously don't know how to use Excel that well.
You can
1. Copy from E4 and select E5 to E? and paste OR
2. With E4 selected, grab the lower right corner of E4 (cursor changes to a +) and drag it down as far as you want. The formula will populate those cells.
Did that help?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
I'm sorry to say it's not. It's still only giving me the first cell. I think I'm going to have to go at this a different way. Thanks for trying to help though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks