Results 1 to 11 of 11

Search row with criteria in all sheet, copy rows and paste in new created sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-20-2013
    Location
    LX
    MS-Off Ver
    Office 2019
    Posts
    164

    Question Search row with criteria in all sheet, copy rows and paste in new created sheet

    Hello.

    What I want is that Excel search in column E in all sheets (in this example abs, cbr, bmw or even more if more sheets exist) all rows with criteria a as team (or others if needed), copy the entire row and paste all founded in a new automatically created sheet in the same workbook, which is named like the search criteria (here as a)

    I'm very new in macros vba so can anybody help me?

    Thanks in advance for your help
    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. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  2. [SOLVED] Search multiple sheets for criteria and paste all matched rows in new sheet
    By BertLady56 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2012, 01:09 PM
  3. Replies: 9
    Last Post: 01-22-2012, 01:31 PM
  4. [SOLVED] Macro to copy and paste rows to a new sheet based on criteria
    By Belo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-31-2010, 02:25 AM
  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