thedudelord
New Member
- Joined
- May 9, 2019
- Messages
- 2
Hi,
I have my workbook set up to show a separate worksheet for each state. The representative from each state will go into their own state worksheet and select their state from a drop down list. When the state is selected, I need to bring in top 5 past due invoices for that state - data set is on a hidden worksheet. Any ideas on how to do this with a formula? I've scoured the internet and cannot find anything. Thank you!
State worksheet:
Drop Down = Atlanta
Need to bring in top 5 instances (highest to lowest Past Due amount) to show:
Cell C53:C57 = Customer #
Cell D53:D57 = Customer Name
F53:F57 = # of past due invoices
G53:G57 = Past Due Amount
Data Worksheet:
Column C = State Name
Column D = Customer #
Column E = Customer Name
Column L = # of Invoices
Column M = Past Due Amount
I have my workbook set up to show a separate worksheet for each state. The representative from each state will go into their own state worksheet and select their state from a drop down list. When the state is selected, I need to bring in top 5 past due invoices for that state - data set is on a hidden worksheet. Any ideas on how to do this with a formula? I've scoured the internet and cannot find anything. Thank you!
State worksheet:
Drop Down = Atlanta
Need to bring in top 5 instances (highest to lowest Past Due amount) to show:
Cell C53:C57 = Customer #
Cell D53:D57 = Customer Name
F53:F57 = # of past due invoices
G53:G57 = Past Due Amount
Data Worksheet:
Column C = State Name
Column D = Customer #
Column E = Customer Name
Column L = # of Invoices
Column M = Past Due Amount