Hi guys,

I'm new to the forum so if I make any mistakes in my post then please feel free to let me know and I will endeavour to change it to comply with forum rules immediately.

Just to explain the problem a little:

Every month I need to consolidate numbers from 2 separate business entities. In Entity 1, Cost X and Cost Y will be classified in two separate cost codes, 'A' and 'B'. Whereas in Entity 2, Cost X and Cost Y will be classified together in 1 cost code, 'C'.

Currently I would just add together the two cost codes in entity 1 to get the equivalent in entity 2. However, cost codes in my company are ever changing and today it might be A + B = C but tomorrow it might be A + D = C. Therefore, I need a dynamic way of easily mapping the data by changing only the mapping fields and excel would automatically map the data for me.

I have attached a sample excel file just for you to get the gist of what I am currently doing.


Really appreciate any and all available help and suggestions.

How_To_Auto_Map.xlsx