Excel Macro

Closed
Maximus - Mar 10, 2010 at 07:00 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 12, 2010 at 09:09 AM
Hello,

I have created a worksheet that I want to develop for a competition entry data collection.

basically i want the 'entrant' to type in their name, email, tel number into sheet one and when they click submit it is stored within another sheet and there current data in sheet 1 is erased so the next person can do this.

Does that make sense? I used to be good on excel at school but not anymore!

Any help would be greatly appreciated.

Thank you

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 12, 2010 at 09:09 AM
What you want to do is pretty easily doable. Could you share that workbook so that solution can be proposed. You can put at some share site like https://authentification.site

The gist of macro would be

1. Find the last row used in the sheet 2 (where cumulative record is to be kept). For this you can use some thing like
lastrow = cells(rows.count. "A").end(xlup).row


2. Copy the information from sheet 1 to right locations on sheet to in the row after the one establish in step 1

3. Clear out the cells from sheet 1 with some thing like

cells(1,2) = ""
0