Populating cells based on calculation

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top