Kapalı

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.

Beceriler: Excel, Veri İşleme, Veri Girişi

Müşteri Hakkında:
( 0 değerlendirme ) Dallas, United States

Proje NO: #34297036

Bu iş için 92 freelancer ortalamada $19/saat teklif veriyor

(525 Değerlendirme)
8.4
(478 Değerlendirme)
8.4
(166 Değerlendirme)
7.3
(315 Değerlendirme)
7.2
(35 Değerlendirme)
6.7
(184 Değerlendirme)
6.5
(125 Değerlendirme)
6.5
(46 Değerlendirme)
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 Daha Fazla

$20 USD / saat tutarından itibaren
(151 Değerlendirme)
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 / saat tutarından itibaren
(118 Değerlendirme)
5.3
(33 Değerlendirme)
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 / saat tutarından itibaren
(46 Değerlendirme)
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 Daha Fazla

$15 USD / saat tutarından itibaren
(38 Değerlendirme)
5.3
(35 Değerlendirme)
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 Daha Fazla

$15 USD / saat tutarından itibaren
(32 Değerlendirme)
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 / saat tutarından itibaren
(7 Değerlendirme)
4.5
(12 Değerlendirme)
4.3
(3 Değerlendirme)
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. Daha Fazla

$15 USD / saat tutarından itibaren
(5 Değerlendirme)
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 / saat tutarından itibaren
(1 Yorum)
3.6