Excel- Automatically Update one Table Based on Input from Another Table

scottnichols1

New Member
Joined
Jan 6, 2016
Messages
8
Hello all. I have 2 tables in separate worksheets (same workbook). First table is tblUnitList, second table is tblUnitLocation. I would like to manage tblUnitList and have tblUnitLocation updated whenever an addition, change, or deletion is made to tblUnitList.

tblUnitlist consists of a header (Row 1) with UnitNo, UnitName, UnitLocation, etc..

tblUnitLocation consists of a header (Row 1) with UnitLocation. Each location then lists the unit for that location.

The reason I have it set up that way is that I am doing some dynamic data validation lists in a form.

I cannot use VBA for this because of the number of end users. Is there a way to use an Index/Match formula in tblUnitLocations to manage the updates?

Thank you in advance.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

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