moving State Data

L

Lime

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.....
 
D

Dave Peterson

I would create a second worksheet with that list of statenames to keep (A1:Axx)

Then add a column to your data that has a formula like:

=isnumber(match(c2,sheet2!a:a,0))
(where column C contained the state)
Drag it down the length of your data.

Filter by that column and copy the visible cells to the new sheet.

Then clean up the original sheet (delete those visible rows) and that helper
column.

Heck you could also copy the sheet to start, then add the formulas to both. On
one sheet keep the Trues and on the other keep the falses.
 
L

Lime

I've using something simaluar, The list & forumla {=or(exact(A:1,
Sheet2"!$A$1:$A$15))}
and then coping over the trues.. Though there might be a to macro it.

Thanks,
Lime
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top