Auto-populating

[xcellnoob]

Hey all,
Thanks to some help here, I was able to pull off a dynamic auto-sorting by date. My new task is to populate different sheets with the data. So, I have stores in the east and stores in the west. On the data entry page, the user enters the region. Based on that entry I want the data to be transferred to either the "East" tab or the "west" tab. I still want the info to autosort though.
The formula I'm using for the autosort is:

=IF(ISERROR(VLOOKUP(Inputs!M18,Inputs!$A$6:$Q$32,2,FALSE)),"",(IF(VLOOKUP(Inputs!M18,Inputs!$A$6:$Q$32,2,FALSE)=0,"",IF(N(Inputs!M18),VLOOKUP(Inputs!M18,Inputs!$A$6:$Q$32,2,FALSE),""))))

So, I am trying to put in another IF statement so that if the cell that holds east/west says east, then put that row on the east tab not the west tab. ANy suggestions?

 

[xcellnoob]

bump for any help?

 

[xcellnoob]

Is my post too vague?
Bumping one last time for any advice.
Thanks.

 

[MarkAndrews]

I would use ms query for this

Are you familiar with MS Query?

 

[xcellnoob]

Negative. What is this MS Query?

 

[MarkAndrews]

Its difficult to explain - maybe look at the function via google & learn from there?

 

[xcellnoob]

can you query from the same workbook that you are in?

 

[MarkAndrews]

can you query from the same workbook that you are in?

Yes, you certainly can

 

[xcellnoob]

So Query works, but it is static. I need it to be dynamic. Is there any way to do dynamic queries?

 

[MarkAndrews]

If you put in a validation & used the parameter, your page results would change to reflect East or West , from your validation selection box