Suljettu

Missing Invoices

We are trying to merge two sheets to where it finds the item on the list of sheet two on sheet one and brings over multiple columns and rows. We tried to do a power query but couldn't get that to work.

I'm attaching the file for example. We need the data from sheet 1 to be pulled over into sheet 2 for only the items listed on sheet 2. Vlookup only brings over one row but each invoice has multiple rows and columns.

Can you help with this?

I have three more months for the merge but attached is just the one of the months.

Taidot: Excel, Tietojenkäsittely, Tiedonsyöttö

Tietoa asiakkaasta:
( 0 arvostelua ) Dallas, United States

Projektin tunnus: #34297036

92 freelanceria on tarjonnut keskimäärin $19/tunti tähän työhön

(525 arvostelua)
8.4
(478 arvostelua)
8.4
(166 arvostelua)
7.3
(315 arvostelua)
7.2
(35 arvostelua)
6.7
(184 arvostelua)
6.5
(125 arvostelua)
6.5
(46 arvostelua)
6.3
merinsinha

Excel VBA expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating Lisää

$20 USD / tunti
(151 arvostelua)
5.6
sobhad20

Hi There, I can do this right now with perfectly. Please message me to start your work now. Regard's Sobha

$15 USD / tunti
(118 arvostelua)
5.3
(33 arvostelua)
5.2
IgeS

Hi there, Do you need the processed output or a VBA-based application for this? Please message and let's discuss about your requirements. I'll be standing by to help. -Ige

$15 USD / tunti
(46 arvostelua)
5.4
nadeeemsarwar

Hi sir! I understood your project requirements perfectly and ready to start right now. Just need to discuss some details on chat. I am offering you an affordable price, however, it may be negotiable after discussing if Lisää

$15 USD / tunti
(38 arvostelua)
5.3
(35 arvostelua)
4.9
MamukaB

hello I can do this project very quick. I think is possible to do all 3 month data together I can do it using Excel VBA . It's very powerful app for like this cases I'm working in Distribution company and I'm doing li Lisää

$15 USD / tunti
(32 arvostelua)
4.5
nawazwasif

Hi sir there are total 36139 records after copy. would you like to get this job done within 10 minutes........ regards

$20 USD / tunti
(7 arvostelua)
4.5
(12 arvostelua)
4.3
(3 arvostelua)
4.0
anenkovakateryna

Hi I've read the project description carefully. I'm an expert in Excel VBA. It would be a great pleasure for me to have the opportunity working with you. ✓ Looking forward to hearing more about your project via chat. Lisää

$15 USD / tunti
(5 arvostelua)
3.8
SteveyLupo

Good Morning. I would love to take on this project. I do loads of data entry for my buisness. I am sure I can help get your issues resolved in a timely manner. Thank you for considering me.

$23 USD / tunti
(1 arvostelu)
3.6