Results 1 to 12 of 12

Copy unique rows based on two cell values

Threaded View

  1. #1
    Registered User
    Join Date
    02-26-2013
    Location
    Engerland
    MS-Off Ver
    Excel 20011
    Posts
    13

    Copy unique rows based on two cell values

    I have a sheet named 'Sales' where invoice data is stored. In cell 'A16' is a list of the customers from which I want to select a customer and then copy all rows where that customer's name is and also where the 'Paid' cell value is set to 'No'. I want to copy it to the 'Statements' sheet from cell 'C14' downward. I've managed to hack some code I've found and this currently will copy all the rows to the 'Statements2' sheet but not based on the customer's name or whether they've paid. I've attached the workbook.
    Many thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare two sheets,copy and paste unique rows based on values in 2 columns
    By ooggiemobile in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2013, 03:58 AM
  2. copy rows based on cell values
    By Galactico076 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2013, 10:49 AM
  3. [SOLVED] Macro - Copy and Combine values in cell and paste it in other cells based on Unique ID
    By haleakala17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2012, 05:41 PM
  4. Copy Rows and Paste Based On Cell Values
    By boohah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2010, 08:58 AM
  5. Can I automate copy of rows based on cell values
    By rveach64 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-20-2005, 02:25 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