[fophis]

I want to make a button that when I push it it pastes the number that is in several different cells in another part of the spreadsheet. its for a finance spread sheet. so I can put in my daily spendings in one part and then I have one cell that adds that up and when I push the button it pastes that number in a cell that is further down the spread sheet. I have it set up with the date in one columns and then to the right of that is a column is a column for spendings, bills, income and savings. I want a button for each so that each week I can put in my check and push the button and it puts that check amount in the column for income on that day that I push the button. and then it adds up that months total income and puts it in a cell at the top. and a button for savings that puts the savings for that month in the savings column. and a button for bills that puts the total for that months bills in the bills column. and for each button I want it to also clear the cells that I have put the information in. if it would help to have the spreadsheet that I have made so you can see it let me know and I will get it to you.
I now know that the special past will past the the value but how can I tell it to put it in the row that corresponds with that date. and I now have made it so there is only one button and it archives everything so I will only do it once a month. I have put in some numbers to show what it will look like but it still needs the macro for the button. I tryed to upload the file but sense I am using open office instead of the real microsoft excel it will not let me load it. its the same thing only free. I have microsoft office on one computer but not all of my computers. trying to keep things legale. so the free download works for me on the other computers. if you wont the file email me at (E-Mail Removed).
thank you