Re: Auto fill unknown values from available data: day, month and year.
Hi TheGlovner
Thanks for your help
I agreee with you that we will have to keep the imputs separate from the calcs.
I have decided to re arrange the setup to a week by week setup so as to be more accurate with a wage input and a bills output.
Still learning 
First post and an infant in regards to excel so thanks in advance.
Im trying to do a bit of an expenditure budget so please bear with me.
[TABLE="width: 500"]
Weekly
[/td]Monthly
[/td]Yearly
[/td]Bills
[/td]Morguage
[/td]
[/TABLE]
If i only have the weekly values of my bills but i want the monthly and yearly columns auto fill
or
If i only have the mothly values of my mortguage but i want the weekly and the yearly columns to auto fill
I have been using some basic code but its not working how i would like it to.
I would also like for the box to retun to formula if the value isnt manually imput.
Hope that all makes sense and TIA
