Results 1 to 9 of 9

Copying/Pasting Rows/Columns based on content

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2006
    Location
    Maryland
    Posts
    50

    Copying/Pasting Rows/Columns based on content

    Good Afternoon!

    I need some serious help with this macro that I am trying to write.

    I have attached the spreadsheet that I am working on. I was trying to write a macro that would cut all of the rows that have "Duplicate claim/service." in column L and paste them into a new worksheet within this workbook. I would also like to cut all of the rows that have a "Y" in column M and paste them into the same worksheet as the "Duplicate claim/services".

    This is a report that is generated daily, the number of rows will vary from day to day. I need this macro to be able to capture ALL of the Duplicate claim/services and ALL of the Y's regardless of how many rows there are in the worksheet.

    This report is a medical claim denial report, all of the "accounts" have to be reviewed EXCEPT for the Duplicate claims and the ones that are marked "Y" for worked.

    I hope this makes sense and I hope someone might be able to help me.

    Thanks,

    Laura S.
    lmsloman@yahoo.com
    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