Excel Macro
Closed
Maximus
-
Mar 10, 2010 at 07:00 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 12, 2010 at 09:09 AM
rizvisa1 Posts 4478 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
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
Related:
- Excel Macro
- Excel mod apk for pc - Download - Spreadsheets
- Spell number in excel without macro - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 12, 2010 at 09:09 AM
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) = ""
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) = ""