+ Reply to Thread
Results 1 to 3 of 3

Adding a row after every existing row that includes vlookup.

  1. #1
    Registered User
    Join Date
    08-07-2009
    Location
    Dublin, California
    MS-Off Ver
    Excel 2003
    Posts
    18

    Exclamation Adding a row after every existing row that includes vlookup.

    Hello.

    Is there a way to automatically add a new row (to create a duplicate of the first tab using = data from first row) after every existing row containing v_look_up data from second tab of same worksheet?

    For example

    1 A (data being pulled from second tab within sme worksheet)
    2 D (data being pulled from second tab within sme worksheet)
    3 G (data being pulled from second tab within sme worksheet)

    Turning into

    1 A (data being pulled from second tab within sme worksheet)
    (empty row)
    2 D (data being pulled from second tab within sme worksheet)
    (empty row)
    3 G (data being pulled from second tab within sme worksheet)

    I need to keep the V_look_up in first row so I can not copy and paste special for when I update the spreadsheet in the second tab I would like for the first tab to update as well. Make sense?

    Thank you in advance.

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Adding a row after every existing row that includes vlookup.

    attach a sample workbook with data.
    it will be easier for someone to provide solution.
    modytrane

  3. #3
    Registered User
    Join Date
    08-07-2009
    Location
    Dublin, California
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: Adding a row after every existing row that includes vlookup.

    I hope this helps...
    Attached Files Attached Files

+ 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