ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Populating cells based on calculation (https://www.excelbanter.com/excel-worksheet-functions/5901-populating-cells-based-calculation.html)

Chris

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



All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com