There were only 100+ rows in example database sheet. Manually adding macro categories(aka mapping) was easy for such smaller data set. However, real world might have much bigger data sets, how should we do mapping there ? It would have been good to see automatic mapping instead of manually doing it. Is there a way to do it ?

Hi Vipin, You can't really do automatic mapping if you haven't done it at least once before. If you have done this exercise for a previous year, then you can do a VLOOKUP (or INDEX&MATCH) to transfer some of the corresponding values. This can't be done automatically the first time though. Best, Ned

Follow this topic

Vipin Gupta

Last answered:

19 Apr 2021

Posted on:

19 Apr 2021

Alternative to manual mapping ?

in Introduction to Excel / Mapping the Rows in the Database Sheet

1 answers ( 0 marked as helpful)

Ned Krastev

Posted on:

19 Apr 2021

Alternative to manual mapping ?

Submit an answer