I am writing to seek help, in creating a macro, which can find and fill in missing rows of data based on the macro logic below.
If name(column B), has either a id1, or id2 or both. I would like the macro to find duplicate names, where one name in row 1, have both of its ids missing and another name, in another row 6 has either one id1, or id2 or both and fill/replace the missing ids in row1, using the logic below; Macro Logic, Only apply the logic to rows which are highlighted red, row name id1 id2 1 m1 3 m1 896736 output 1 m1 896736 3 m1 896736 2 y1 909H63 6 y1 output 2 y1 909H63 6 y1 909H63 7 u1 dh54793 8948jyu 8 u1 output 7 u1 dh54793 8948jyu 8 u1 dh54793 7 r1 8948jy 5 r1 hy75894 8 r1 hy75894 output 7 r1 8948jy 5 r1 hy75894 8 r1 hy75894 (e.g.) if name(u1), in row 2 has both ids (id1 & id2) and in row 5, the same name has no ids,* then the desired output would be to, fill in row 2 name, with only id1, not id2. * Please see example 3(name u1), for further clarification. I have attached a sample dataset below, labelled as input and desired output worksheets. Input sample data: https://app.box.com/s/qy25eognzpo1u29mjwyv Output sample data: https://app.box.com/s/kie9kzbd0hya9byax6zb Any help would be very much appreciated. Many thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
