Linking/mirroring an Excel table to another table

If the contacts are specific to one of the user forms, I'd be inclined to add a column with the form ID on it. Then you can sort the list alphabetically and/or alphabetically within a Form ID.

List the Contact IDs on the Table for each form and then use Index/Match or VLookup to populate the details.

Regards, TMS

Hello and thank you for the quick reply. I'd not thought of the Match function actually, I'll have a look at using it.

I should have been more detailed in my query as well. There are no user forms on the spreadsheet - the term 'form' was used in reference to the 5 former spreadsheets (forms) used for jobs. The way the contacts currently sit are just in 5 Excel Tables and as you say, the contacts are specific to each table.

Initially, I just did a simple '=' function so that a cell just mirrored one from the table, but this does not allow situations where an extra row may be added or cells be merged.

Thanks again for your response, having a go at this through dinner.

You're welcome.


If you need any further help or advice, I suggest you post a sample workbook with some typical data.


Regards, TMS

Just a note, if you plan on merging cells, the whole thing will go down the drain. No formula will automatically merge cells on the mirror image. Formulas also cannot automatically mirror some cell formatting (like bold, sub and superscript, etc.). They cannot mirror random color decisions.

I'm also interested to seeing any solutions to this problem

You can't do that without VBA and even then it's a PitA. Don't do it.

@RFraser86 ... by the way ...

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.