[swicklund]

I have a list of data on an excel worksheet, and would like to extract all data for a given state on another worksheet. Data keeps getting added to the first worksheet, and would rather not have to sort, copy, and paste everytime I want to do an analysis.

Is there a simpler way to do this?

Thanks,

[Advertisements]

data for a given state as in...state in the union? (ie texas florrida ohio) or state is in data from a specific state of the file?

[dsenette]

data for a given state as in...state in the union? (ie texas florrida ohio) or state is in data from a specific state of the file?

[swicklund]

State of the union (MN, MI, WI, etc....)

[dsenette]

i don't remember the full syntax in exell but you'll want to use an if statement there...it would end up being (logically) if this collumn(first page) is TN then this collumn(second page) is the data for tn on the first page...some kind of horse hockey like that...

[swicklund]

I was afraid it would be something like that. I was hoping there would be a quicker method.

Thanks,

[warriorscot]

Have you tried using a database instead if its being used that regularly, they are harder to set up to begin with or at least they can be but it might be worth you looking into if you use it everyday.

[swicklund]

warriorscot,

Yes I have, and that is the way that I would do it. I have a friend taking an Excel class, that asked me for help. I was trying to help her go above and beyond.

Thanks,

[warriorscot]

Ah right i see, yeah excel has alot of bells and whistles but sometimes you have to bite the bullet and switch to the more appropriate software.

I think youre stuck with either the conditional statement formula, or writing a macro for it.