+ Reply to Thread
Results 1 to 5 of 5

Saving Data To Next Empty Sheet ?

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Saving Data To Next Empty Sheet ?

    Let's say you have a UserForm that saves entries to Sheet1. Each row of the sheet is utilized for a single "record".

    Over a period of time you have managed to use all 1.4 million rows. Now there is a need to have the UserForm save
    the entries to Sheet2 because it is the next empty sheet.

    Without making a manual selection of Sheet2 or changing the macro code to save to Sheet2 ... how would you code
    your macro the automatically identify the next empty sheet and proceed ? And ... after Sheet2 is full ... go on to Sheet3 ...
    then to Sheet4 ?

    Thanks.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Saving Data To Next Empty Sheet ?

    With over 2 million rows of data, I'd no longer be using Excel for data storage...
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Saving Data To Next Empty Sheet ?

    Better I code to create a new worksheet to save the data when the last row reaches the last cells of that worksheet.

    When I create a new worksheet I mention the sheet name somewhere in the cell or in named range so that based on it the code will save the new data's.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Saving Data To Next Empty Sheet ?

    Quote Originally Posted by Olly View Post
    With over 2 million rows of data, I'd no longer be using Excel for data storage...
    Better go for Ms-Access or SQL Server

  5. #5
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Saving Data To Next Empty Sheet ?

    If you must use Excel, however, here's one approach:

    Please Login or Register  to view this content.

+ 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. Transfer data from the main sheet to another sheet depending on empty cells
    By Joky in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 01-19-2018, 04:01 PM
  2. [SOLVED] Populating forms with new or existing data and saving to a data sheet.
    By u3rick in forum Excel Programming / VBA / Macros
    Replies: 306
    Last Post: 12-01-2015, 02:55 AM
  3. Need Help with VBA Saving DATA to another sheet
    By cpalmere in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-25-2013, 10:41 AM
  4. Replies: 2
    Last Post: 06-12-2013, 07:41 AM
  5. Replies: 8
    Last Post: 01-31-2013, 02:55 AM
  6. Replies: 1
    Last Post: 11-13-2012, 02:06 PM
  7. Saving data to a second sheet
    By jaikin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2009, 10:48 AM

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