Extract Rows & Prepair specific format

[hecgroups]

Dear Keeb,

Hello Again.

I am looking for a help to upgrade the existing file which you have help me before. Before you created multiple list but I am adding here with agreed % which nee dot reflect in a report.

A sample is attached for output for the Statement sheet.

Until extraction it is good and working fine. Now I need to prepare statement as sown in the attachment with specific format with agreed % for each record.

Calculation explained in the file itself.

Still if you have any question please let me know.

[Keebellah]

Got it, will download the file and see it it's clear, won't be right away but ... i'll try asap

[hecgroups]

Take your time I am not in urgent situation.

Thank you for your help.

[Keebellah]

Hi, Try this, I think it works as you want.

[Keebellah]

Noticed some cosmetic issues.
Corrected these and have attached latest version.
Hope to hear if it works like intended

[hecgroups]

Dear Keeb, Thanks for your swift response.

It is working can you explain what you have done.
Also can it be possible for individual provider (Through Search Provider Button)

[Keebellah]

Well if you read the code that you already had, check for the new caption and there's a a section that does just that part, adds the value based upon the provider code just above Grand Total row, and the function is simple it looks up the passed provider code and returns the value in the Agreed percentage
What do you mean with with the second part?
Can you be more specific please?

[Keebellah]

I tried using the other form and it works too.
Selected one and it did the same thing.

[hecgroups]

Hi Keeb,

It works for me

Thank for saving my lot of time.

[Keebellah]

You're welcome, and since you have time to spare take the time to read the vba code and you'll see it's not that difficult