Hi all and i appreciate taking the time just read this, i have a fairly simple understanding of excel but have taken it upon myself to set a new detailed family budget and run sheet, what i'm after is some help working out what formula/coding i need.
what i'm trying to do is sheet 1 (bills) has a new bill column what i want is to be able to enter figures into the correct cells then once I have finished use a form control button to add the figures to a column on sheet 3 without having to keep those numbers on sheet 1 as reference essentially creating a running formula to tally up the years bills as i go.
i hope this has made a little bit of sense i know what i'm thinking but not sure how to explain.
PS. I can't seem to work out how to take screen shots but this laptop just keeps printing the screen.
what i'm trying to do is sheet 1 (bills) has a new bill column what i want is to be able to enter figures into the correct cells then once I have finished use a form control button to add the figures to a column on sheet 3 without having to keep those numbers on sheet 1 as reference essentially creating a running formula to tally up the years bills as i go.
i hope this has made a little bit of sense i know what i'm thinking but not sure how to explain.
PS. I can't seem to work out how to take screen shots but this laptop just keeps printing the screen.