Change table data according to drop list

A

Arthurtaggart

New Member
Joined
Dec 8, 2013
Messages
1
Say I have a 2 tables, 'orders' and 'profits'. How can I make a table so that it will show the profits for the year, according to the year selected in the drop-list table. I need to know ASAP its the tast task i have for my work and is due in a few days.

Thankyou
 
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

T
  • Solved
How can I filter duplicates from a worksheet column out of a data validation list drop-down box?
Replies
5
Views
409
Peter_SSs
Peter_SSs
M
  • Question Question
Can excel return results that are calculated from separate items in a drop down list
2 3 4
Replies
33
Views
1K
Peter_SSs
Peter_SSs
S
  • Question Question
HYPERLINK() function Seems Unable to Jump to Another Sheets Table and Filter
Replies
6
Views
747
Skyybot
Skyybot
R
  • Question Question
Data Validation Matching
Replies
3
Views
324
etaf
etaf
A
  • Question Question
Lookup Help! Data table is dynamically dependent on data present in a row against which lookup is needed.
Replies
1
Views
611
asadriaz
A

Share this page

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