Extract Rows & Prepare specific format 2022

Hi, will take a look.
Won't be 'til after the weekend.
Have to read-up on the code again and freshen my memory to see what I did and can do for you

Hi, just got back, hiere is just the idea how to read more than one entry for duplicate codes

Please Login or Register  to view this content.

I only did the dubug.print but this you can change to an array that is filled and returned as answer
It's late now so I'm off to bed

I told you that my code does NOT return a value, it just shows you how the routine looks like when you have more than one found item

You will have to explian it better.
I do not see where what goes, I just showed you how to find more than one code if it is duplicated or more

Maybe this ies what you are looking for
Added a parameter to the coode I had posted

The mistake is that you did not check the code I have.
You forget to pass the yearval

this is the correction you need

Please Login or Register  to view this content.

Add the line of code I have marked in red

It’s all in the details 😉
Glad to have been able to help you.
“IT” Always crosses your path ...

Just to help you understand my idea.
The function to search for the agreed percentage takes two parameters, first the provider code and second the year value in column C, that is the last four characters in that cell as number.
This is then used to identify which provider code from the Lists sheet you need and it also cross-checks the year value in the date column

In case you want to setup the Satement (Final) worksheet for printing (landscape) you can try this macro

Please Login or Register  to view this content.

Place it in a separate module or add it to an existing module (but then ignore the Option Explicit)
It takes a default boolean parameter as false to put it all don without page breaks, if you pass it as TRUE the worksheet will be split per Satement

I added the call line here

Please Login or Register  to view this content.

if you call it like this it will split the worksheets

Please Login or Register  to view this content.

Might come in handy

Hi, I noticed you did not take a look anymore at the print seteup.
Just out of curiosity I modified the code and reduced the number of VBA codelines that were repeated making it easier to maintain.
Nothing much but just some brain gymnastics for me