Data from sheet1 to sheet2 automatically

[Karlj]

Hello everyone and thanks in advance for looking at my question.

Soooo.... I am trying to make a spreadsheet that i can put in my fortnightly income in sheet1 and then it will automatically transfer that data in to sheet2.

Sheet1

Will have separate boxes for entering
income
Loan payment
Hours worked
tax paid

Sheet2
Will store all this information so it can be used by other macros i don't know how to make :P

Column A = Income
Column B = Loan Payment
Etc.

I would really like it if you could spend a bit of time explaining what the parts of the code do so i can then try and make sense of it and maybe even modify it if need be.

Many thanks in advance

 

[mumps]

In which cells in Sheet1 are your Income, Loan payment, Hours worked and Tax Paid? Will any of these cells be blank at any time? Are the values entered manually or are they the result of a formula?