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.
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.