Results 1 to 16 of 16

Macro to copy rows (in a range) based on a cell criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-25-2012
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    201

    Macro to copy rows (in a range) based on a cell criteria

    Hi. I'm dealing with a problem. I have a worksheet that has several rows that starts with Back, Lay, Market P/L or Commision in collumn A.
    The thing is i want to copy the rows in a range Ax:Gx (where x is the row number) and paste then (AS VALUES) in a new sheet (named DATA) in cell A1. But i want it to copy only the rows in that range where the cell in the collumn A starts as Back. If it says Lay, or Commision or Market P/L, that row in that range wont be copied.
    The result would be a DATA sheet where from A1 to Ax with no gaps between all rows only be visible the rows which start as Back in A cell.
    I attached a file with the data so its more perceptible,
    If anyone could help i would be really apreciated.

    Thank you.
    Attached Files Attached Files

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