C
Chris
Hi
Acc Po Raised Po Paid
Cols Cols Cols
A B C D F G H I Q R S T U
I want to search each number from Col Q and if found in Col F then populate
Cols A,B,C, D from Cols F,G,H,I until a blank cell is found in Col Q. Also
When I move to another month. Data in Cols A,B,C,D to be carried forward and
then this operation to be repeated and so on for the 12 months
Cheers
Chris
Acc Po Raised Po Paid
Cols Cols Cols
A B C D F G H I Q R S T U
I want to search each number from Col Q and if found in Col F then populate
Cols A,B,C, D from Cols F,G,H,I until a blank cell is found in Col Q. Also
When I move to another month. Data in Cols A,B,C,D to be carried forward and
then this operation to be repeated and so on for the 12 months
Cheers
Chris