These questions both relate to an invoice set up in a worksheet.
1. After I have finished an 'invoice' I want to transfer some data onto another worksheet called Sales Journal. I need a macro that can copy 5 cells and paste them into the Sales Journal (one at a time, not all together). But problems occur because one of the cells from the invoice is made up of a calculation so when this copies over I just get the formula rather than the figure. Then the data has to be pasted below existing entries.
2. Once the above is done I want to clear the invoice so I can enter someone else's details. Now the macro to clear the details if fine, what I want to add to it though is an automatic incrementation of the invoice number. I have no clue how to do this.
Any idea's? Would be grateful for help [grin]
1. After I have finished an 'invoice' I want to transfer some data onto another worksheet called Sales Journal. I need a macro that can copy 5 cells and paste them into the Sales Journal (one at a time, not all together). But problems occur because one of the cells from the invoice is made up of a calculation so when this copies over I just get the formula rather than the figure. Then the data has to be pasted below existing entries.
2. Once the above is done I want to clear the invoice so I can enter someone else's details. Now the macro to clear the details if fine, what I want to add to it though is an automatic incrementation of the invoice number. I have no clue how to do this.
Any idea's? Would be grateful for help [grin]