Re: $$Excel-Macros$$ Re: fill in the missing data for highlighted rows - macro request

2014-07-07 Thread jun a
Dear Vabz, Apology for the very late response. Thank for the amazing solution and your hardwork into this. The macro works great, many thanks for making changes to the macro. I really appreciate your help and time. Have a great day/evening! :) Thanks a million -- Are you =EXP(E:RT) or =

Re: $$Excel-Macros$$ Re: fill in the missing data for highlighted rows - macro request

2014-07-01 Thread jun a
Hi Vabz, Thank you very much for your great help. The logic works great, but I am sorry to keep burdening you again but I am unable to get the macro to work on dataset of 100,000 lines of data. It seems crash after 5/7mins. Overall, the macro only works on 100 lines of data,* not on anythin

$$Excel-Macros$$ Re: fill in the missing data for highlighted rows - macro request

2014-06-30 Thread jun a
Dear Vabz, Apology for the late response, as i was trying to solve some issues with the code by myself, but sadly i did not get very far. The logic is great but the macro only seems to works on that sample_input worksheet, as I tried to copy the macro onto new worksheet (please see the new a

$$Excel-Macros$$ Re: fill in the missing data for highlighted rows - macro request

2014-06-28 Thread jun a
Hi, Thanks a lot for your help and your time into this solution, i am sorry to inform, as the logic is slightly incorrect. if i run the id2 macro, it fills row 21 (please the example file above) id2 with value, where it should only have id1 value. if its not much trouble, to combine the ma

$$Excel-Macros$$ Re: fill in the missing data for highlighted rows - macro request

2014-06-27 Thread jun a
Please use the sample data in the attachment for further example of the problem explained above, as the links above do not work. Thank you for your time and help. -- 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

$$Excel-Macros$$ fill in the missing data for highlighted rows - macro request

2014-06-27 Thread jun a
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