Will require good skills in VBA for Microsoft Excel to create a module.
1. Loop through each cell of column A one by one from top to bottom.
2. Compare each cell of column A to contents of column D, identify common strings.
3. If match is found, continue loop through column A and begin to copy contents of all cells below the match into corresponding row of column D, i.e. Into E, F, G, H, etc.
4. Continue loop until another match is found.
5. If 2nd match is found, continue loop and begin to copy contents of all cells below the 2nd match into corresponding row of column D, i.e. Into E, F, G, H, etc.
6. Continue loop until no more matches are found.
Hello, i reviewed the Master Data file you attached and i have few simple questions for you. If you are interested in working with me, please message me and i will try to help immediately. I believe i can code this in less than an hour, and i can start immediately.
Thanks, Milan
$25 USD in 0 day
5.0 (429 reviews)
6.9
6.9
5 freelancers are bidding on average $27 USD for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews, they speak for themselves.
Best regards
Hello,
I am Excel and VBA expert.
I have seen the file. I understand the requirements.
I can do it in VBA (Excel VBA macro).
If you have any questions, I will be happy to answer.
Please note that I have 100% completion rate and 5-star feedback on over 80 projects.
Jan
Hi, I am a Data Analyst with strong experience in Data and Business Analysis. I work on tools like MICROSOFT EXCEL, VBA, TABLEAU, SAS and R Programming