Hello all. Was just hoping for a little help on something I think should be fairly simple… I’ve been trying for 3 hours but cannot work it out! Within our company, we used to have 5 different forms which were issued for 5 different types of jobs. Instead of having all these separate forms which were difficult to maintain, I have now combined those forms into one with a nice welcome sheet allowing the user to press a button to select the form they want (the macro will then hide all other sheets not relevant and leave the user with just the sheets they need). Nice and easy, not a problem so far.

My issue however surrounds the linking of a table. Each form currently has a contact page at the beginning with a list of names, numbers, etc. relevant to that form. What I want to do is have these 5 contact pages listed as Excel Tables separately on one master page (which can be updated in one go) – the aim then would be for the user to make a change on this master page (say a contact number changes), and it then be updated on the page that contact list is from.

So for example…

1. Someone changes their number.
2. I’d be able to go to the master contacts page, update that number
3. The number will then link and show on the contact page on the relevant form.
4. Next time someone chooses that form on the welcome sheet, they can be sure it has the most up to date contacts on there.

I’m fairly Excel confident having worked things out through the use of a few books and talks with colleagues, but I’m really stumped with this one!