View Single Post
  #1   Report Post  
Chris
 
Posts: n/a
Default Populating cells based on calculation

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