Forum Discussion
Blank workbook when first opened until key dates are entered.
Hello,
In the attached workbook, I would like the three colored tables to be blank when opening until a couple of dates are entered.
Once Cell B6 is a manually entered, Cell A19 = that date. Then the rest of that row will automatically populate.
Then when Cell B7 is manually entered the rest of the rows fill in up to that date.
When additional months are needed, it will automatically pull the last needed month from Cell B45’s value and add the info to the gray table.
2 Replies
- drt_80Copper Contributor
I am creating this for other people to use. I am wanting it to be as simple as possible for them to use. The only cells I want them in is A1:B12 and columns J,K,& L. I am fairly new to excel, therefore i am not sure of the correct formulas to use to achieve what i am wanting. Thanks. gs_aujla