Make mapping visable or visual

[Franky_B]

Hallo Everyone,

I am looking for way to make mapping of fields visible.
I have to versions of HTML files and I need to map from A to B,
Has anyone an idee how to solve this in Excel?

Exampl mapping.png

[AliGW]

Welcome to the forum.

Those connector lines could be added manually. If you wish to automate it, then you will certainly need VBA and you will need to show the logic of the connections (Excel will not intuitively know what theyare).

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[Franky_B]

HI Ali, thanks for your helpful feedback!

[AliGW]

So please read my first sentence again - which of the two are you wanting? If you want it automating, I need to move this to the VBA section for you and you need to provide a key for the allowed matches.

[Franky_B]

Hi, sorry for misunderstanding.
I want to connect manually,

In my example draw a line or arrow from cell E9 to G6.
And when I insert a row in "Model B" the connection between "E" and "W" the must stay

[AliGW]

Yes - to make it 'stay', you'll need VBA and you'll need to define a list of matches.

I am moving the thread for you.