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
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

A
  • Question
Lookup Help! Data table is dynamically dependent on data present in a row against which lookup is needed.
Replies
1
Views
387
asadriaz
A
M
  • Question
VBA vs Formulas/Data Validation for Multiple Dependent Dropdown Lists
Replies
3
Views
499
MissDB101
M
L
  • Question
Excel Calendar using data from a list.
Replies
2
Views
562
Lali2023
L
H
  • Solved
VBA to Copy a worksheet from a template, then increment a drop down list in each new copy by one.
2
Replies
10
Views
1K
kevin9999
K
J
  • Solved
Get data from dynamic location and filename on closed workbook using VBA
2 3 4
Replies
33
Views
1K
eiloken
E

Forum statistics

Threads
1,215,046
Messages
6,122,852
Members
449,096
Latest member
Erald

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