+ Reply to Thread
Results 1 to 6 of 6

Updating Worksheets with new data without deleting old data

  1. #1
    Registered User
    Join Date
    03-26-2014
    Location
    Toronto
    MS-Off Ver
    MS Excel for Office 365
    Posts
    29

    Updating Worksheets with new data without deleting old data

    Good evening experts, I have another need of your expertise!

    I'd like to update my worksheets with new data from a worksheet in the same workbook.

    I have a worksheet(let's call it Master) that pulls data from other sources. I actually already use a macro to grab the new set of data. Master will contain the new set of data that I'd like to be copied to the other existing worksheets based on a value and worksheet name.

    For example, in the attached, I have the 1st column that contain an indicator value. I'd like to have all the rows that contain the worksheet name in the 1st column to be copied to the worksheet. In the specific example, I'd like to have the rows where Column A = Toronto to be copied to the worksheet named Toronto, New York to the worksheet New York, etc.

    There will already be existing data in the worksheet named Toronto, so I'd like to have the new data added instead of overwriting the worksheet.

    The "indicator" column is just the 1st column for simplicity's sake, but I'm hoping we can change this one to whichever column.

    I actually already use a macro that does a similar function except it completely creates new worksheets. I got it from this video, maybe this can serve as an inspiration? = https://www.youtube.com/watch?v=5bOFNsdHiPk

    Thank you in advance! Your input is very much so appreciated!!

    z
    Attached Files Attached Files
    Last edited by zed369; 06-19-2019 at 12:53 PM. Reason: Solved

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: Updating Worksheets with new data without deleting old data

    Try
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Cool Hi ! Try this ‼


    Good morning !

    Quote Originally Posted by zed369 View Post
    There will already be existing data in the worksheet named Toronto, so I'd like to have the new data added instead of overwriting the worksheet.
    For this king of stuff, using Excel basics is faster than creating any code like here a filter.
    So when really a code is needed, the easy way is to use the same Excel basics …

    According to your attachment a demonstration as a beginner starter :

    PHP Code: 
    Sub Demo()
            
    Dim W%
                
    Application.ScreenUpdating False
        With Sheets
    ("Master").UsedRange
                
    .AutoFilter
            
    For 2 To Worksheets.Count
                
    .Columns(1).AutoFilter 1Worksheets(W).Name
                
    .Offset(1).Copy Worksheets(W).Cells(Rows.Count1).End(xlUp)(2)
            
    Next
                
    .AutoFilter
        End With
                Application
    .ScreenUpdating True
    End Sub 
    Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !

  4. #4
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,095

    Re: Updating Worksheets with new data without deleting old data

    Hello Zed,

    Here's another option:-


    Please Login or Register  to view this content.
    I hope that this helps.

    Cheerio,
    vcoolio.

  5. #5
    Registered User
    Join Date
    03-26-2014
    Location
    Toronto
    MS-Off Ver
    MS Excel for Office 365
    Posts
    29

    Re: Updating Worksheets with new data without deleting old data

    I apologize for the delay, everyone! Thank you so much! They worked!!

  6. #6
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,095

    Re: Updating Worksheets with new data without deleting old data

    You're welcome Zed!

    Glad that we were able to help.

    Cheerio,
    vcoolio.

+ 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] worksheets not auto updating when i add new data
    By chriswrcg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2018, 10:27 AM
  2. add and updating data to two worksheets
    By jack2305 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2018, 03:20 PM
  3. Updating Records /Deleting non-duplicate data?
    By Ryguy786 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2012, 05:14 PM
  4. Data updating in following worksheets.
    By lordbeariofbow in forum Excel General
    Replies: 2
    Last Post: 12-06-2011, 01:59 AM
  5. [SOLVED] Combining 2 worksheets in to 1 & deleting data
    By nighttrainrex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-13-2011, 11:39 PM
  6. Updating data from separate worksheets
    By Rcob87 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2011, 07:09 AM
  7. Updating of data between worksheets
    By alien3011 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2007, 01:25 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