+ Reply to Thread
Results 1 to 13 of 13

Create sheets based on cell entry

  1. #1
    Forum Contributor
    Join Date
    01-23-2020
    Location
    Namibia
    MS-Off Ver
    2016
    Posts
    110

    Create sheets based on cell entry

    good day

    i have this excellent macro

    when u click on it you put the 1st day of the month based on your pc clock for eg. 07/01

    then it asks you for the second date which is 07/31

    it will then start listing the dates from 1 to 31 excluding weekends.

    i want however that when it happens to also create new sheets immdeiately. the sheets names should be the respective date and it should start from the last sheet that was used.
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Create sheets based on cell entry

    Possibly...
    Please Login or Register  to view this content.

  3. #3
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: Create sheets based on cell entry

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  4. #4
    Forum Contributor
    Join Date
    01-23-2020
    Location
    Namibia
    MS-Off Ver
    2016
    Posts
    110

    Re: Create sheets based on cell entry

    Thank you the first one worked

    Please Login or Register  to view this content.
    Now i want it to start generating from the last sheet and it must also load a template sheet

  5. #5
    Forum Contributor
    Join Date
    01-23-2020
    Location
    Namibia
    MS-Off Ver
    2016
    Posts
    110

    Re: Create sheets based on cell entry

    i just have one more favour to ask. When the macro runs it inserts the dates the way it should be. then it also inserts the sheets based on their dates. There is a template sheet i want in all those dates.

    Please adjust the code in the attached workbook then i can close this thread solved and give an excellent reputation
    Attached Files Attached Files

  6. #6
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Create sheets based on cell entry

    Which worksheet in the workbook is the template?

  7. #7
    Forum Contributor
    Join Date
    01-23-2020
    Location
    Namibia
    MS-Off Ver
    2016
    Posts
    110

    Re: Create sheets based on cell entry

    The one called Receipt

  8. #8
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Create sheets based on cell entry

    Possibly...
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    01-23-2020
    Location
    Namibia
    MS-Off Ver
    2016
    Posts
    110

    Re: Create sheets based on cell entry

    Thank you sir

    it worked like a charm. there are still another favour to ask regarding the same worksheet but thank you for now

  10. #10
    Forum Contributor
    Join Date
    01-23-2020
    Location
    Namibia
    MS-Off Ver
    2016
    Posts
    110

    Re: Create sheets based on cell entry

    is there a macro that can delete these worksheets created based on their dates?

  11. #11
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Create sheets based on cell entry

    Possibly...
    Please Login or Register  to view this content.

  12. #12
    Forum Contributor
    Join Date
    01-23-2020
    Location
    Namibia
    MS-Off Ver
    2016
    Posts
    110

    Re: Create sheets based on cell entry

    It once again worked like a charm

    i had another vba macro that i found on the internet but the coding was too cumbersome. This once works 100%

  13. #13
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Create sheets based on cell entry

    Glad I could help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to create sheets based on cell value
    By AccountingJ in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-12-2018, 03:12 PM
  2. [SOLVED] Create Table based on data entry in cell
    By cobbrjr in forum Excel General
    Replies: 9
    Last Post: 06-12-2018, 12:20 PM
  3. [SOLVED] VBA to create sheets based on cell values
    By AccountingJ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-23-2018, 04:05 PM
  4. Create sheets based on cell data
    By Spawn-Swe in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-20-2016, 09:49 AM
  5. Replies: 2
    Last Post: 01-12-2015, 02:27 AM
  6. [SOLVED] Create sheets based on Cell A name
    By Christopherdj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-05-2015, 04:24 AM
  7. macro to copy a range of worksheets based on cell entry and rename specific sheets
    By Lbischoff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2012, 12:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1