I wad wondering if anybody could help me with my IT work as I have no bloody idea how to do this, and it is driving me mad!
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