For a school project i'm working on, i have to create a spreadsheet for holding customer details and financial details for some imaginary company. What i need to do is basically have a data entry form on one worksheet, and a button on that worksheet that'll cut+paste all the data thats been entered, into a list of past entries that have been made.
What i basically need is a code that'll take the contents of say cell C11 from Worksheet1, and place it into cell G4 in Worksheet2, but the next time run the code, it'll take the contents of cell C11 and place it into G5, then G6, then G7 etc...
Thanks in advance.
Edited by Welshhobo, 08 March 2010 - 04:23 PM.