Auto-populating

xcellnoob

Board Regular
Joined
Apr 6, 2005
Messages
188
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:
Code:
=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?
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

xcellnoob

Board Regular
Joined
Apr 6, 2005
Messages
188
Negative. What is this MS Query?
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Its difficult to explain - maybe look at the function via google & learn from there?
 

xcellnoob

Board Regular
Joined
Apr 6, 2005
Messages
188
can you query from the same workbook that you are in?
 

xcellnoob

Board Regular
Joined
Apr 6, 2005
Messages
188
So Query works, but it is static. I need it to be dynamic. Is there any way to do dynamic queries?
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
If you put in a validation & used the parameter, your page results would change to reflect East or West , from your validation selection box
 

Forum statistics

Threads
1,181,897
Messages
5,932,682
Members
436,850
Latest member
Jasperlee93

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top