Stephen Green-Price
New Member
Hi there,
I have a dynamic Table 1 as follows:
Tram A ---- Time 1, Time 2, Time 3, Time 4, Time 5
Tram B ---- Time 1, Time 2, Time 3, Time 4, Time 5, Time 6
Tram C ---- Time 1, Time 2, Time 3, Time 4
Tram D ---- Time 1, Time 2, Time 3
Tram E ---- Time 1, Time 2, Time 3, Time 4
And then another dynamic list (Table 2) here that I would like to match the Tram ID and populate the Times automatically from Table 1:
Tram A ---- (auto populate with Table 1 times)
Tram D ---- (auto populate with Table 1 times)
Tram E ---- (auto populate with Table 1 times)
The trams in Table 2 could change automatically, so would need to list the times for the same Tram ID found in Table 1. I would like to avoid VBA as much as I can please to keep it user friendly.
Thanks for your help!
I have a dynamic Table 1 as follows:
Tram A ---- Time 1, Time 2, Time 3, Time 4, Time 5
Tram B ---- Time 1, Time 2, Time 3, Time 4, Time 5, Time 6
Tram C ---- Time 1, Time 2, Time 3, Time 4
Tram D ---- Time 1, Time 2, Time 3
Tram E ---- Time 1, Time 2, Time 3, Time 4
And then another dynamic list (Table 2) here that I would like to match the Tram ID and populate the Times automatically from Table 1:
Tram A ---- (auto populate with Table 1 times)
Tram D ---- (auto populate with Table 1 times)
Tram E ---- (auto populate with Table 1 times)
The trams in Table 2 could change automatically, so would need to list the times for the same Tram ID found in Table 1. I would like to avoid VBA as much as I can please to keep it user friendly.
Thanks for your help!