Announcement

Collapse
No announcement yet.

Excel: Search OR Filter

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel: Search OR Filter

    Hi,
    Just say i had an Excel Workbook which contained 100 worksheets and lets say for instance the name Hayes appeared in about 100 cells spread out across the 100 worksheets, would it be possible with a search or filter to find the name Hayes and group all the rows together into one worksheet? hope i have explained it so you understand.

    Any response would be greatly appreciated.

  • #2
    Re: Excel: Search OR Filter

    Almost certainly possible using macros or an add-in

    I didnt dig into any of the links here but it should help get you started:
    http://www.google.co.uk/search?hl=en...rksheets&meta=

    Ain't wonderful!

    Tom
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment

    Working...
    X