I am trying to create a macro that will use info from one column to choose a word and every row that has that word plus the addition data in the rows will be copied into another tab.

if column B contains the word "accounting" then i want all the data (10 or so columns) around 50 rows copied into a new tab so i can graph it.

any help appreciated.

Thanks!