Ditutup

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.

Kemahiran: Excel, Pemprosesan Data, Pemasukan Data

Tentang Klien:
( 0 ulasan ) Dallas, United States

ID Projek: #34297036

92 pekerja bebas membida secara purata $19/jam untuk pekerjaan ini

(525 Ulasan)
8.4
(478 Ulasan)
8.4
(166 Ulasan)
7.3
(315 Ulasan)
7.2
(35 Ulasan)
6.7
(184 Ulasan)
6.5
(125 Ulasan)
6.5
(46 Ulasan)
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 Lagi

$20 USD / jam
(151 Ulasan)
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 / jam
(118 Ulasan)
5.3
(33 Ulasan)
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 / jam
(46 Ulasan)
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 Lagi

$15 USD / jam
(38 Ulasan)
5.3
(35 Ulasan)
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 Lagi

$15 USD / jam
(32 Ulasan)
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 / jam
(7 Ulasan)
4.5
(12 Ulasan)
4.3
(3 Ulasan)
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. Lagi

$15 USD / jam
(5 Ulasan)
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 / jam
(1 Ulasan)
3.6