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

2014-07-07 Thread Vaibhav Joshi
Cheers!! Glad it worked for you.. On Mon, Jul 7, 2014 at 8:07 PM, jun a wrote: > 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

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 Vaibhav Joshi
Hi Check dis..if you find any prob then share sample data with 5000 + lines, i test on 6000 lines & data got filled in less than 30 sec. Cheers!! On Tue, Jul 1, 2014 at 4:31 PM, Vaibhav Joshi wrote: > It should not be so.. let me re-test it. > > > On Tue, Jul 1, 2014 at 4:30 PM, jun a wrote:

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

2014-07-01 Thread Vaibhav Joshi
It should not be so.. let me re-test it. On Tue, Jul 1, 2014 at 4:30 PM, jun a wrote: > 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

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

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

2014-06-30 Thread Vaibhav Joshi
Hi PFA Pl let the code be in separate module & not in sheet module. I had mapped last row on Col A due to which you might not be getting result on all Rows.. Cheers!! On Mon, Jun 30, 2014 at 8:32 PM, jun a wrote: > Dear Vabz, > > Apology for the late response, as i was trying to solve some

$$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

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

2014-06-28 Thread Vaibhav Joshi
Ok. I got that.. will try tomo morning India Time. Cheers & Good Night. On Sat, Jun 28, 2014 at 11:49 PM, jun a wrote: > Hi, > > Thank you for your reply. Apology for not making my statement clear > enough. > > I have attached a example below, for further reference to this issue. > When I r

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

2014-06-28 Thread Vaibhav Joshi
file which you sent doesnt have duplicated value for *lbmt 2007-c3 ajfl* On Sat, Jun 28, 2014 at 9:46 PM, jun a wrote: > 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 (p

$$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