V-Lookup, C&P Multiple values

Hi all,

Hoping you can help, I am trying to learn VBA and I have spent 2/3 hours googling this but I either don't understand the code or it doesn't answer what I am trying to do! ARGGHHH

I work in insurance at going forward I have to run 2 reports
Report one: Transaction - this details all the business transaction for the primary introducer
Introducer report: This details all the introducer that are getting paid on the policy
Our system can only issue a report based on primary introducer, it doesn't combine several in a single report - hence the 2 reports.

I need to code a macro that with merge this 2 reports into a single sheet. The main info that shows on both reports is the invoice reference which I want to you to look up all the introducers connected to that record.

Attached is a draft excel sheet.

Sheet 1: Transaction: This pulls the primary introducer details/client details and any agents connected
Sheet 2: Introducer: This is where it lists any introducer connected to that invoice ref is shown
Sheet 3: Results: This is where I want the date pasted to, above each heading is the cell there the data is stored. Ie Colum B is client name and Above is "T-K" meaning Transaction sheet "Sheet 1" column K.

I have abbreviated the data and deleted others for DPA reasons.

Please can someone help!

PS - if anyone has any good sites to learn basic VBA etc, please do send links so I can try and learn more, if you can help with the code, please do let me know what the code is asking so I can at least understand what it is doing to help with future changes.

Please update your spreadsheet so that the column headers in the results page correlate to the headers in your source pages. They don't correlate right now therefore we can not match them.

Originally Posted by maniacb

Please update your spreadsheet so that the column headers in the results page correlate to the headers in your source pages. They don't correlate right now therefore we can not match them.

Thanks for coming back, I assume you mean the text has the be the exact same - have amended them all - there are 2 headed that are static and don't need to be copied over. Result L & Q.

My biggest problem is there could be multiple pay aways
Primairy introducer
Agent
Secondary intro
3rd intro

Primary and agent come from transaction sheet, the secondary and third intro come from the introducer sheet. - hope that makes sense.

So on the results sheet under U/V and W/X these are pulled from the introducer sheet but will have the same headings.

Thanks in advance - much appreciated

Here you go. I used the Introducer sheet as the primary and then add data from Introducer and Transaction sheets. Let us know if you have questions.

Sorry for the delay in coming back, thank you for sending over the attached. unfortunately using the introducer tabs doesn't work as it pull through all the lines of data. I only need to data connected to the primary introducer, ie that on the trans sheet.

I believe someone has now given me a solution on this using power query. I will be testing it this morning.

Thank you for trying, I suspect my explanation wasn't clear enough originally so apologies for that.

Appreciate your help nevertheless

For thoroughness, here you go

Please Login or Register  to view this content.