Travisallen2007
New Member
- Joined
- Jan 21, 2018
- Messages
- 30
- Office Version
- 365
I have two tables and need Table A (Which is changeable) To source its data off table B. I am not sure how to set this up and any help would be greatly appreciated.
Table A
A23:A31 is changable Word corresponding to cash amounts. Drop down based on table at E53:F60 (Also now called table B)
B23:B31 Is where the user types in quantities of the dollars they have
C23:C31 is where i need it to calculate to dollar value from Table B associated with the choice they selected in A23:A31 multiplied by B23:B31
Table B:
E53:E60 is the titles of the drop downs that will be selectable for A23:A31 (With one exception listed below)
F53:F60 is the dollar amounts that need to be used based on the selection chosen in table A A23:A31 and later used to multiply showing total dollar amount in cells C23:C31
The only exception to this is for pennies, nickels, dimes and Qtrs that never change. Pennies are always .50, Nickels always 2, dimes always 5, and quarters always 10.
Thanks again for any help!! Really appreciate it!
Table A
A23:A31 is changable Word corresponding to cash amounts. Drop down based on table at E53:F60 (Also now called table B)
B23:B31 Is where the user types in quantities of the dollars they have
C23:C31 is where i need it to calculate to dollar value from Table B associated with the choice they selected in A23:A31 multiplied by B23:B31
Table B:
E53:E60 is the titles of the drop downs that will be selectable for A23:A31 (With one exception listed below)
F53:F60 is the dollar amounts that need to be used based on the selection chosen in table A A23:A31 and later used to multiply showing total dollar amount in cells C23:C31
The only exception to this is for pennies, nickels, dimes and Qtrs that never change. Pennies are always .50, Nickels always 2, dimes always 5, and quarters always 10.
Thanks again for any help!! Really appreciate it!