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.
92 pekerja bebas membida secara purata $19/jam untuk pekerjaan ini
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
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.