Suoritettu

Merge two Excel sheets with info

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Microsoft Access

Näytä lisää: programmers numbers, programmers excel, i need excel help, excel, visual basic for apps, data entry data processing, microsoft excel, macro excel merge sheets, excel merge sheets, excel sheet display info sheets, excel info sheets dynamic, excel merge info spreadsheets, excel merge data photoshop, name sheets excel using vbscript, importing user info joomla excel, excel merge files mail duplicates, computer inventory sheets excel

Tietoa työnantajasta:
( 63 arvostelua ) SEM, Norway

Projektin tunnus: #9168552

Myönnetty käyttäjälle:

best4best

I have clearly understood your requirement and can merge it as you want using formulas. You can also use this formula easily.

$25 USD 1 päivässä
(192 Arvostelua)
6.5

102 freelanceria on tarjonnut keskimäärin 55$ tähän työhön

jaylancer43

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 Lisää

$50 USD 0 päivässä
(698 arvostelua)
8.4
Ibrahim185

Hi, After reviewing the project description I know that I'm an excellent fit for this [login to view URL]'s discuss and start right now. Awaiting for your positive reply thanks.

$100 USD 3 päivässä
(867 arvostelua)
8.0
FINGERRPRINT

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

$100 USD 2 päivässä
(331 arvostelua)
8.1
mirniyazuddin92

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 Lisää

$60 USD 1 päivässä
(396 arvostelua)
7.9
jubair7

Let's discuss more and finalize the project and cost. We have our own workplace with 7+ working PCs and laptops, with ~15mbps internet connections. And we never out re-source our projects that we have taken from our cl Lisää

$100 USD 3 päivässä
(332 arvostelua)
7.8
livegoodlife

A proposal has not yet been provided

$70 USD 3 päivässä
(246 arvostelua)
7.9
zExcel

A proposal has not yet been provided

$65 USD 1 päivässä
(259 arvostelua)
7.7
Khurramz

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.

$39 USD 2 päivässä
(376 arvostelua)
7.5
bouslimi1979

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 Lisää

$45 USD 3 päivässä
(282 arvostelua)
7.6
deepbluetech

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

$60 USD 1 päivässä
(181 arvostelua)
7.3
P0L

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.

$75 USD 1 päivässä
(302 arvostelua)
7.3
fhasanbd

A proposal has not yet been provided

$100 USD 2 päivässä
(238 arvostelua)
7.1
cugamelover

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 Lisää

$80 USD 1 päivässä
(192 arvostelua)
7.1
elqueabandona

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 Lisää

$75 USD 1 päivässä
(221 arvostelua)
6.9
ZedExcel

Hello, KINDLY MESSAGE ME AS I AM UNABLE TO INITIATE A CHAT WITH YOU. I will be glad to provide you a solution for your project. I have used formulas to merge the two sheets. Kindly message me so that I can send y Lisää

$35 USD 1 päivässä
(35 arvostelua)
6.8
afua23

Excel expert here. I can get this done for you. Please attach a small portion of the excel with the data so i can have a look at it. With your requirement i'm sure i can do it with excel formula. Awaiting your reply Lisää

$40 USD 1 päivässä
(62 arvostelua)
6.5
watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

$15 USD 0 päivässä
(255 arvostelua)
6.5
raghav1101

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 Lisää

$54 USD 2 päivässä
(99 arvostelua)
6.6
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 260 projects. Please look at the feedback left by my employers to know more about my work. Wai Lisää

$50 USD 2 päivässä
(176 arvostelua)
6.5
katilinas

I CAN do this job, and do it well! If you look at my portfolio you will see that my skills are a good fit. Do You need a freelancer who can fulfill all of your requirements? IF SO, push the button "Hire me!" - I think Lisää

$30 USD 2 päivässä
(121 arvostelua)
6.6