Create worksheets from Excel list
Closed
Laura
-
Jun 7, 2011 at 12:10 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2011 at 05:44 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2011 at 05:44 PM
Related:
- Create worksheets from Excel list
- Create skype account with gmail - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Counter strike 1.6 cheats list - Guide
- All contact number list with name - Guide
- How to change your best friends list on snapchat to 3 - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 7, 2011 at 12:31 PM
Jun 7, 2011 at 12:31 PM
On a sheet, bascially you have to start the values that you want to appear as sheets from Cell A10. It will start processing each value from Cell A10, till the last row. Only catch in this code is that you should have at least value in Cells A10 and A11. The other thing is that there should not be any blank cell in between. Last but not the least is that, the sheet that you are trying to add should not exist before
Jun 7, 2011 at 01:15 PM
Jun 7, 2011 at 05:44 PM
Enter the data in the sheet (start from Cell A10, do not leave a11 blank either, and dont leave any blank cell and dont repeat any value. Also ensure that all for all values that you are entering, you do not have a sheet already)
press ALT + F11 at the same time to open vbe
paste the code
press F5 to run the macro