Aussie5380
New Member
- Joined
- Sep 30, 2022
- Messages
- 32
- Office Version
- 2019
- Platform
- Windows
Hey there,
New to macros, but learning a lot. Needing some assistance with finalizing a calculator i have created.
Basically i want 2 lots of cells to generate (One with a fortnightly date, and one with a $ amount which is worked out in the calculator)
It looks like this:
I want the recovery dates hidden, and the amount per pay hidden until there is a number in the above highlighted cell, and for it to only generate the number of lines listed in the above cell (in this case 5 pays has been set so i want to see 5 dates listed and the amount per pay, which is already calculated in the sheet)
I have tried conditional formatting, and im not a big fan of it, and its still leaving to much room for human error.
Is this possible through a macro? And how would i apply this?
Thanks for your help!
New to macros, but learning a lot. Needing some assistance with finalizing a calculator i have created.
Basically i want 2 lots of cells to generate (One with a fortnightly date, and one with a $ amount which is worked out in the calculator)
It looks like this:
I want the recovery dates hidden, and the amount per pay hidden until there is a number in the above highlighted cell, and for it to only generate the number of lines listed in the above cell (in this case 5 pays has been set so i want to see 5 dates listed and the amount per pay, which is already calculated in the sheet)
I have tried conditional formatting, and im not a big fan of it, and its still leaving to much room for human error.
Is this possible through a macro? And how would i apply this?
Thanks for your help!