+ Reply to Thread
Results 1 to 4 of 4

Macro for inserting row and adding data to an existing database

  1. #1
    Registered User
    Join Date
    01-24-2009
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    61

    Macro for inserting row and adding data to an existing database

    Hi, i have got a database which has about 6k rows, every month i get about 200 fresh data (rows) which i have to add to the database. the trick is these fresh entries can be in any part of the database, but the best part is the existing data will match with the fresh database

    For e.g.

    existing database next month output

    item value 1 item value 2 item value 1 value 2
    a 10 a 20 a 10 20
    b 20 aa 10 aa 20 10
    c 30 b 30 b 30 30
    c 40 c 40


    I will have to search where this aa has been added and insert a new row and the data to it. and i have to do it for the whole 6k rows!

    Can anyone pls suggest a way / macro to solve this issue. It would be of great help

    Thanks

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Macro for inserting row and adding data to an existing database

    It's not clear for me, attach a sample file with current table and desired result
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    01-24-2009
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    61

    Re: Macro for inserting row and adding data to an existing database

    Oops, sorry i should have previewed my post before posting, i didn think it would post it as text. Pls find attached a sample file
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-24-2009
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    61

    Re: Macro for inserting row and adding data to an existing database

    I think we only need to add rows and add column A data. Then we can use vlookup function to add the value column i guess

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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