The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Macro for Mapping

Back to all questions

Macro for Mapping

10 months ago
Vote Up Vote Down
0
Votes
1
Answer

Right now I am currently working through the excel portion of the courses. In coming along I watched the mapping video where it encourages you to try to make your own mapping macro for different categories for a P&L Statement. I am having difficulty thinking of how that would be written. I was hoping for a step by step process that could explain that portion.
I appreciate any answers that will help me learn how to fix this problem!

#, #, #
1 Answer

365 Team 10 months ago
Vote Up Vote Down
0
Votes

Hey Ryan,
Sorry for the delayed reply.
There isn’t a macro we can build to facilitate this the first time we are carrying out the mapping exercise.
Once we have done it, we can use VLOOKUP or INDEX&MATCH to transfer entries for items that have been assigned already.
Best,
Ned

You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #, #, #.

JanuaryPromo
×
Complete Data Science Education
Get 50% OFF