Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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..... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
moving State Data
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. Lime wrote: 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..... -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
moving State Data
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 "Dave Peterson" wrote: 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. Lime wrote: 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..... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace state names with state code abbreviations | Excel Worksheet Functions | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
How do you plot data points on a state map? | Charts and Charting in Excel |