+ Reply to Thread
Results 1 to 1 of 1

Auto copy rows to different sheet when specific column is filled

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Iceland
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Auto copy rows to different sheet when specific column is filled

    Hi
    I'm trying to automate a sales quote sheet with selected products/rows from a main price list sheet. I have this "All Products" sheet with appx. 500 rows and 12 columns. When an item is selected - number of the item is put in column "F" - I would like to auto copy 9 of the 12 columns in that row to a different sheet "Quote" The items list in the "All Products" sheet start in row 9 but in the "Quote" sheet the selected items could start in row 5.
    I´ve attached a sample xlsx file with part of the list.
    Hope this is clear enough - thanks for any response.
    Kind Regards
    Agust
    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)

Similar Threads

  1. HELP PLEASE! Moving rows to another sheet dependant on certain column being filled
    By NickyNoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2014, 09:19 AM
  2. [SOLVED] Copy rows with specific text in specific column into specific sheet
    By Valemaar in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-22-2014, 03:23 PM
  3. Copy rows with values in specific column to first empty row in specified sheet
    By scaffdog845 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2013, 08:29 PM
  4. Copy multiple rows only if column is filled in
    By soldevi53 in forum Excel General
    Replies: 7
    Last Post: 02-09-2012, 03:11 AM
  5. how do i copy only the coloured filled rows in excel to new sheet
    By Kate at work in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2006, 01:15 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