Merging 3 workbooks when they are not exactly the same

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’m trying to merge 3 workbooks to get a list of vendors with TIN, address,
last activity, last updated ID & last time updated etc and encountered a few
problems. (One workbook has vendor name, last activity, last updated etc,
another vendor name, TIN etc and the last one vendor name, address, last
updated etc.)

My “Compare and Merge workbooks†option is grayed out so I couldn't try it.
My lists are not identical (one has 38,449 rows, another 23,566 rows and
20,915 rows) and the “last updated ID & last time updated†columns are not
the same in those 3 files.

Is there a way for me to compile what I need into one worksheet?

Thanks!
 
You have three files.
Is it not easy to manually rearrange the columns before copy and paste them
together please?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

look up formula 9
Merge 3 cells in one 1
merge workbooks 1
Merge multiple worksheets into one 1
How to find and move a value based on multiple criteria 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Vlookup plus other function/s combinations required? 5
Search for rows in one sheet and copy into another sheet based on customer id 1

Back
Top