Results 1 to 5 of 5

Copy and Paste rows to multiple worksheets based on a cell value.

Threaded View

gaidon Copy and Paste rows to... 07-22-2013, 11:29 AM
StephenR Re: Copy and Paste rows to... 07-22-2013, 12:07 PM
gaidon Re: Copy and Paste rows to... 07-22-2013, 12:24 PM
StephenR Re: Copy and Paste rows to... 07-22-2013, 12:33 PM
gaidon Re: Copy and Paste rows to... 07-22-2013, 12:43 PM
  1. #1
    Registered User
    Join Date
    07-22-2013
    Location
    Washington US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Copy and Paste rows to multiple worksheets based on a cell value.

    So I have been reading through the forums trying to see if this was figured out already but am having no luck. I have a worksheet that has a master page. From that page I need to look at the number in column k and then copy the entire row to a corresponding sheet in the workbook. So if 1 is in column k the entire row gets copied into sheet "1 gallon". This goes up to the number 14 so anything 14 and above gets put into the "14 gallon" sheet.

    Thank you in advance for any help you can give.
    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. Copy and Paste rows to another spreedsheet based on multiple sets of criteria.
    By juhaszp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2013, 11:08 AM
  2. Unique Copy and Paste Macro - Multiple Worksheets Based on IF (AND) criteria
    By dwalt75 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-16-2013, 04:49 PM
  3. copy rows from multiple worksheets to a new condition based on criteria
    By TheVoodoo in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-20-2012, 02:37 PM
  4. Insert a number of rows based on a cell value and copy formulas on multiple worksheets
    By Charleneq40 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2012, 12:45 PM
  5. Copy\Paste multiple criteria based rows to new sheet
    By namz in forum Excel Programming / VBA / Macros
    Replies: 46
    Last Post: 06-06-2008, 08:08 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