+ Reply to Thread
Results 1 to 4 of 4

Find term on one sheet, put corresponding row on another sheet

Hybrid View

  1. #1
    Registered User
    Join Date
    01-22-2008
    Posts
    2

    Find term on one sheet, put corresponding row on another sheet

    I have a multisheet work book. One of the sheets I want to be a summary page. I'm looking for an equation that will look at all the sheets for one term, if the term is found, I want it to put the corresponding row of information on the summary sheet.

    Ex:
    Sheet 1
    Delete Joe 5 $15
    Jane 6 $12

    Sheet 2
    Amy 2 $38
    Delete Josh 4 $3
    Kim 6 $2

    I want the summary sheet to show only:
    Delete Joe 5 $15
    Delete Josh 4 $3

    Note: Each word/number is in it's own cell.

    Is this possible?

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Please post a representative sample workbook (zipped XL2003 file please).
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    01-22-2008
    Posts
    2

    Attaching Zip file for an example

    In the attached file you will see three worksheets. I want all the rows in all the worksheets that have Delete in the first column to display in the Adds&Delete worksheet.
    Attached Files Attached Files

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Probably the best way is to Autofilter by Delete in column A from each sheet and paste to the summary sheet...

    or to use some VBA code....but I am not a VBA expert.....

+ Reply to Thread

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