Hi there would like some help please.
I have the following macro that looks at the data in the "F" column of sheet ShA "Current" and then puts the relevant rows cell data on sheet ShB "Paid"
If it finds a "P" in F it then looks to columns "G and "H"
G will always have a number and H is either "ca" of "ch" .
I now need it to also look for "dp" in H.
It then takes the data in cells A, B G, H from ShA "Current"and copies the relevant data to "ShB "Paid" to columns A,B,C,D, and the new column in ShB for dp would be E
I hope mu explanation makes sense !
Many thanks if you can help
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Bookmarks