Results 1 to 2 of 2

Copying duplicate rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    Vriezenveen, Holland
    MS-Off Ver
    Excel 2003, 2010
    Posts
    1

    Copying duplicate rows

    Hello everyone,

    i hope someone can help me out; i put the question in the excelsheet, but here a summary;

    With vlookup i gathered some results from other worksheets.
    There is a column called "Firm" with a standard value "3000"

    Now i need to do the following; for every row i found results (the formula in the upper row will be copied down every time) i need a duplicate of that record with only one modification; the value "3000" has to be replaced in the duplicates with 3005, 3010 and 3010

    Please please help me!!! Thank you all in advance!!
    Attached Files Attached Files
    Last edited by edtwiest; 11-11-2015 at 05:34 AM. Reason: I wanted to move this thread to formulas/vba, but i can't change it ?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Merge Duplicate Rows unique values into single rows for an infinite amount of columns/rows
    By aimeecrystalaid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2013, 08:43 PM
  2. [SOLVED] Delete rows based on duplicate cell, but leaving first and last duplicate.
    By LadyNicole in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2013, 05:07 AM
  3. VBA helps needed to Sum duplicate values and delete duplicate rows
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2013, 11:40 PM
  4. Preventing duplicate entry of a row in Sheet 2 while copying selected rows from Sheet 1
    By Pavan Renjal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-31-2012, 04:27 PM
  5. Replies: 5
    Last Post: 11-12-2012, 08:38 PM
  6. [SOLVED] Sum Duplicate values then delete duplicate rows
    By keekdapolak in forum Excel General
    Replies: 7
    Last Post: 09-20-2012, 02:57 PM
  7. [SOLVED] Conditional formatting of duplicate rows (not duplicate cells)
    By ExcelStefan in forum Excel General
    Replies: 2
    Last Post: 06-19-2012, 06:09 AM
  8. Copying Duplicate rows
    By terryvanduzee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2006, 11:00 PM

Tags for this Thread

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