Merge two Excel sheets with info
$10-100 USD
Bezahlt bei Lieferung
Hello.
I need some help with two Excel sheets.
Excel sheet 1 contains a column (And others) named ArticleID.
Excel sheet 2 have a column called ArticleID and one column named UPC.
In Excel sheet 1 the ArticleID column contain unique numbers, so that no rows contain the same ArticleID.
In Excel sheet 2, ArticleID could be in multiple rows.
I need either a program or a Excel formula that will do the following: (I will need to be able to do this work also at a later stage with similar Excel sheets)
- Merge Excel sheet 2 into Excel sheet 1.
- Excel sheet 2 will match ArticleID and put the UPC number in the correct row. (The same row that contains that ArticleID)
- In my Excel sheet 1, column A-H are in use.
Example:
If an ArticleID are present 3 times in Excel sheet 2, the 3 different UPC numbers would be present in row I, J and K in Excel sheet 1, in the row that contains the same ArticleID.
If an ArticleID are present 6 times in Excel sheet 2, the 6 different UPC numbers would be present in row I, J, K, L, M and N in Excel sheet 1, in the row that contains the same ArticleID.
Just ask if you have any questions. Programmers that can do this fast will be prioritized.
Projekt-ID: #9168552
Über das Projekt
Vergeben an:
I have clearly understood your requirement and can merge it as you want using formulas. You can also use this formula easily.
99 Freelancer bieten im Durchschnitt $55 für diesen Job
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Mehr
we can match them with vlookup. I am good at excel and can do it correctly. I have been here since 2009 and having lot of experience. Looking for long term relationship
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information Mehr
Hi, I ll code a VBA macro for this. Since you want to use it for futur files, it will work as follow : 1) select the 2 input files to merge 2). make the merge 3) generate the output file in a new sheet 4) the possibili Mehr
Hi, I can create a formula that can be used easily, instead of complex programming. I'll also explain how to use the same in future. Please send me chat if you need any details.
Hello, my name is Cristian, i have a degree in Business and owrk with excel everyday. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regar Mehr
Hi, I am an Excel automation expert and would be happy to take on your project. Let me know and I can start working on it right away. Regards, Arul
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your pro Mehr
Hello there, I understood your job desc, i can do this, am good at excel and formulas, and data handling, please let me know if i can help you with this. Thank you Anu
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards C Mehr