View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GregR GregR is offline
external usenet poster
 
Posts: 246
Default Pick projects from sheet and create new sheet per project

I have a sheet that is subtotaled by project and each project has
several rows. There is a column (G) which identifies the project. There
are over 35 projects on the sheet. What I want to do is pick 8 known
projects from the list and copy the identified rows associated with the
project to a new sheet. The projects are indentified by a project #
like 00-000-000-000-000. Any help would be appreciated. TIA

Greg