Results 1 to 47 of 47

Copy\Paste multiple criteria based rows to new sheet

Threaded View

namz Copy\Paste multiple criteria... 05-23-2008, 01:35 AM
rylo HI Can you please attach a... 05-23-2008, 01:43 AM
namz Okies..Sample worksheet... 05-23-2008, 02:09 AM
rylo Hi This assumes that you... 05-23-2008, 09:06 PM
namz THanks a ton rylo...much... 05-24-2008, 09:18 PM
  1. #1
    Registered User
    Join Date
    03-25-2008
    Posts
    66

    Copy\Paste multiple criteria based rows to new sheet

    Hi All,

    I need to copy specific rows that have a specific value in colum B and Colum M to new worksheets.

    So from attached screenshot , say for an example macro shud filter rows that have "BigPond" in coloum B ,"RG2" in column M & "INT" in column W and i dont want all cells in these rows , i only want copy cells under column C,AK,AL,AM (in this order) to my other excel sheet that is named "BigPond" and it should paste it starting from Row5. ??

    I want to avoid recording a macro as it selects a range and i am expecting more new rows every week so if a record a macro the cell range for selection changes and i get incorrect result.

    Any HELP , ADVICE or a code for this ..plzzzz??

    See the attached screenshot to see my main worksheet from where all this data is coming from...

    Thnkz.
    Attached Images Attached Images

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