Find in listing and copy value

[umpire_43]

Hi there

I'm having a hardtime trying to find the right coding to accomplish this
task:

1) i have two sheets that has data information that Chargeback and Payback
that will be applying a filter for each sheet.

2) Have another sheet named Grid ( this include different accounts names in
Column b. In Column i and j row 5 have the results(summing what was filter)
from the Chargeback and Payback sheets.

the issue is that The account name will change Rows every month in column b
on the Grid sheet so i want to find that account name in column b Ie Renvene
A and apply the the total in Cells I5 and J5 to the Adjacent Row under Column
i and j that match the Revenue name.

Can someone help?


thanks for your help.

Keith

 

[A possible solution]

Sharing a specific sample might help with soliciting some suggestions.

Best wishes,
Rolf