View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lime Lime is offline
external usenet poster
 
Posts: 56
Default moving State Data

Hello,
I have a sheet with all the states in it, with other data in the same
row.What I would like to do is move certin states (whole row) to a new sheet.
so say I want CT NJ NY PA DV OH WV MA RI VT.
L:1 = Plan, Plan indicates the state, but I need the whole header row
all the cells below L:1 are the differant 50 states some show more than once.
I would like to be able to pull only certin ones. and move to a new sheet.
keeping the format of the pull sheet.
Is this possible??

Thanks.....