+ Reply to Thread
Results 1 to 6 of 6

update and add rows to a destination table from my source table

  1. #1
    Registered User
    Join Date
    03-23-2011
    Location
    Egypt
    MS-Off Ver
    Excel 2007
    Posts
    30

    update and add rows to a destination table from my source table

    Hi,

    I've two table on is a source and the other on is a destination id the data I want to display.

    All what i need is a macro to update the current IDs and get the new IDs from the source to destination

    Thanks alot

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: update and add rows to a destination table from my source table

    Try the attached.
    Last edited by AB33; 01-05-2014 at 05:31 PM.

  3. #3
    Registered User
    Join Date
    03-23-2011
    Location
    Egypt
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: update and add rows to a destination table from my source table

    thanks alot for the quick response.

    I have a problem with the code in the attached sheet. in this Line

    Please Login or Register  to view this content.
    I dont want to remove contents specially from column A and E.

    I just to need to update the linked data to each ID in the destination table and copy the new rows only.

    because In this code the data linked in column E to each ID bcomes not matching and not accurate after running the macro

    Thanks again

  4. #4
    Registered User
    Join Date
    01-05-2014
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2000, OpenOffice Calc 4.0.1
    Posts
    1

    Re: update and add rows to a destination table from my source table

    mido609,

    I think this will solve your problem.
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: update and add rows to a destination table from my source table

    I have included the last code I wrote to with the attached. I hae removed it and the code should work with sheet1

  6. #6
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: update and add rows to a destination table from my source table

    The code works on ID match. If the match does not exist, it copies that row.

+ 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] Summary table updated from source table. Source table held in a different workbook
    By dma1976 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-22-2013, 11:36 AM
  2. change(update) pivot table data source.
    By Berserk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2012, 08:21 AM
  3. Update source data from pivot table
    By bryanbak3 in forum Excel General
    Replies: 0
    Last Post: 01-12-2012, 05:28 PM
  4. Update the source database of a pivot table
    By manny_cb in forum Excel General
    Replies: 2
    Last Post: 10-16-2008, 06:18 PM
  5. [SOLVED] How to update destination file with source files closed?
    By Alex Costache in forum Excel General
    Replies: 2
    Last Post: 08-01-2006, 05:10 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