steviejy2k
New Member
- Joined
- Dec 9, 2008
- Messages
- 8
I am a complete newbie to VBA and am trying to make a simple (supposed to be) spreadsheet for people to file expenses with.
I have managed to formulate the spreadsheet so that it looks up £ to € exchange rates for particular days automatically, but I am now trying to make a macro which allows users to insert a new expense into the form.
I require the macro to move a selection labelled TOTALS down a row, and then copy the formulae from other rows down to the new row below. That's not particularly well explained.
Basically i have one row which is formatted correctly with formulae etc, and i want when the user clicks the macro button for the totals (which are two lines beneath) to be moved down a row, and the formatted row with formulae to be copied to the next row below. The important formulae in cells have labels attached so if i can use these it may be easier?? I'm guessing here.
Sorry for the poor explanation.
(P.S. I haven't written any code yet to give you a start as i didn't know where to start.)
Thanks for any help.
I have managed to formulate the spreadsheet so that it looks up £ to € exchange rates for particular days automatically, but I am now trying to make a macro which allows users to insert a new expense into the form.
I require the macro to move a selection labelled TOTALS down a row, and then copy the formulae from other rows down to the new row below. That's not particularly well explained.
Basically i have one row which is formatted correctly with formulae etc, and i want when the user clicks the macro button for the totals (which are two lines beneath) to be moved down a row, and the formatted row with formulae to be copied to the next row below. The important formulae in cells have labels attached so if i can use these it may be easier?? I'm guessing here.
Sorry for the poor explanation.
(P.S. I haven't written any code yet to give you a start as i didn't know where to start.)
Thanks for any help.