Quote:
|
Originally Posted by ntl customer
Basically I have a system where I have a form inside a spreadsheet and when I click a button to which I have assigned a macro to and it is supposed to copy all the fields to a 'database' sheet. I do this by recording a macro and copying and pasting the cells individually into the rows of the database.
That does that fine but I can't seem to get it to go onto the next line when it has finished pasting all the fields in. If you press the button with the macro assigned to it it just overwrites the fields from the previous transfer.
How do you get it to go onto the next line? I need an 'idiot's guide' please, so don't use any jargon and take it step by step - I am no expert at Excel and I have work due at the end of this week - not good! 
Thanks |
It will always do this because when you record a macro it saves the absolute values of the cell numbers you are copying from and too - so everytime you run it, it will copy from the same cells, and paste to the same cells.
The only way I can see to do it, is as mentioned above - write some custom VBA code.
If you have never done this before (written code) then a week is asking rather a lot. Even if you have written code before, then learming a new macro language in 3/4 days is a challange.