looking up data and displaying it in another sheet depending on selection criteria

westie1871

New Member
Joined
Sep 17, 2009
Messages
12
Hi,
I currently have an Excel spreadsheet one sheet has a listwith all my job data. I have a separate sheet with my selection criteria andthen I wish to populate another sheet based on the selection criteria do youknow if this is possible if so how do I go about doing it.

For Example: -
Data Sheet
Date |JobNumber | Postcode | Weight | units
01/03/2018 12345 WA65 9BP 100 1
02/03/2018 23456 M25 200 3
Then my Selection Sheet

Route 1 Route2
WA65 M25


So I want to look at the first set of DATA then look at myselection sheet and then post the results into another sheet either in route 1or route 2

I hope this explains my problem.

Thanks in advance
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Forum statistics

Threads
1,213,560
Messages
6,114,309
Members
448,564
Latest member
ED38

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
Back
Top