1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

copying multiple rows one below the other from different sheets based on filter codn.

Discussion in 'Business Applications' started by NewBeeNeedsHelp, Nov 25, 2012.

Thread Status:
Not open for further replies.
  1. NewBeeNeedsHelp

    NewBeeNeedsHelp Thread Starter

    Nov 25, 2012
    Hi everyone,
    I am new to this Forum.
    I have a workbook with multiple sheets Sheet1, Sheet2, Sheet3, etc.) each with similar information with same column headings. I want to copy multiple rows from each of these sheets into a common Summary sheet based on:

    1. if the column value (Column J) is greater than zero

    2. if the column (Column B) contains a certain word such as "Total", "New", or "Summary"

    I need to create and use two seperate macros one for each of the above conditions.

    I hope I was clear enough in explaining my situation. Attached also please find the sample data. Appreciate your help and direction! Thanks a lot!!!


    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1078201

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice