Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas

I started out with what I thought would be a simple project to solve fluctuating budgets problem.

What I basically have is a 4 columns in a spreadsheet labeled "Weekly" "Fortnightly" "Monthly" & "Yearly"

I wish to be able to fill in a figure in ANY of the 4 columns and extrapolate the correct figures into the other 3 columns i.e If I have $20.00 in the Fortnite column, divide this by 2 to get the weekly figure, multiply the fortnite figure by 26 and divide by 12 to get the monthly figure and so on. I've tried using all sorts of formulas and lots of "if" and "then" statements but ended up with a mess.

I want to be able to put an amount into any of the 4 columns and have the other 3 calculated out and filled in.
I'm sure that somebody a lot more clever than me has already done this..
Can any body point me in the right direction.

Cheers and thanks for reading...

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

VBA offering:

Please Login or Register  to view this content.

Code is in Sheet1: right click on tab==>"View Code" ==> copy/paste

Enter a value in any of the columns.

JohnTopley that is exactly what I need. Is there any way to shift it across to start in column 'B' and also add a quaterly column?

Thanks,
John