carrieohara
New Member
- Joined
- Jul 11, 2017
- Messages
- 2
Hi, let me start by saying I don't know much about excel. I don't work with it regularly but I was asked to try and figure something out for my boss.
I have exported data from two separate sources, there is very little in common between the two except for the customer names and the amounts that they have paid. I have placed the data from the exports onto separate sheets, named eBay and Solid within one workbook.
What I have been asked to do is to locate all the customers who appear on the eBay sheet within the Solid sheet, and merge all of the data pertaining to each one onto one sheet. I tried setting up relationships between the two sheets based on the field "name" but I keep getting an error stating that both columns contain duplicate data. I have gone through every entry on the ebay sheet and renamed any entry that matches another on the same sheet, but I continue to get the error.
At this point I could have gone through the entire list manually, twice probably, but that's not what I was asked to figure out. I know there is a way to do this, it seems simple enough, but I can't figure it out. I know next to nothing about formulas or the finer points of excel, so please take mercy and explain thoroughly if you think you have a solution.
I have exported data from two separate sources, there is very little in common between the two except for the customer names and the amounts that they have paid. I have placed the data from the exports onto separate sheets, named eBay and Solid within one workbook.
What I have been asked to do is to locate all the customers who appear on the eBay sheet within the Solid sheet, and merge all of the data pertaining to each one onto one sheet. I tried setting up relationships between the two sheets based on the field "name" but I keep getting an error stating that both columns contain duplicate data. I have gone through every entry on the ebay sheet and renamed any entry that matches another on the same sheet, but I continue to get the error.
At this point I could have gone through the entire list manually, twice probably, but that's not what I was asked to figure out. I know there is a way to do this, it seems simple enough, but I can't figure it out. I know next to nothing about formulas or the finer points of excel, so please take mercy and explain thoroughly if you think you have a solution.
