Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-22 Thread Ashish Kumar
Welcome...!!! -- 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,

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-22 Thread Pravin Gunjal
Thanks. On Thu, Jan 22, 2015 at 5:00 PM, Ashish Kumar wrote: > Hi, > > Hardly it's take 3 second for showing Batch Details. > > Did you checked the count of Batch Data which was in the user form. The > Count is more than 5000. It's heavy..!! > > > > Yes We have two more Alternate Options for it

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-22 Thread Ashish Kumar
Hi, Hardly it's take 3 second for showing Batch Details. Did you checked the count of Batch Data which was in the user form. The Count is more than 5000. It's heavy..!! Yes We have two more Alternate Options for it. First is, Use the First Sheet, which I'hve send to you on dated 17th Jan. S

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-22 Thread Pravin Gunjal
Hi I am working with it and observed that while opening the window for batches it's taking much time. Can we do something for it. On Tue, Jan 20, 2015 at 7:28 PM, Ashish Kumar wrote: > Thanks. Pravin ...!! > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's > =TIM

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-21 Thread Ashish Kumar
Hi Vaibhav Bhai, Thanks..!! Regards Ashish -- 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 ti

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-21 Thread Ashish Kumar
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, N

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-21 Thread Vaibhav Joshi
Its owesum... Cheers~!! ᐧ On Tue, Jan 20, 2015 at 11:05 AM, Pravin Gunjal wrote: > Good Morning, > > It's fantastic... > > On Mon, Jan 19, 2015 at 9:13 PM, Ashish Kumar > wrote: > >> Dear Pravin jee >> >> PFA >> >> >> >> Regards >> Ashish >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-20 Thread Ashish Kumar
Thanks. Pravin ...!! -- 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,

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-19 Thread Pravin Gunjal
Good Morning, It's fantastic... On Mon, Jan 19, 2015 at 9:13 PM, Ashish Kumar wrote: > Dear Pravin jee > > PFA > > > > Regards > Ashish > > -- > 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:

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-19 Thread Pravin Gunjal
Dear Ashish jee Its fine and working good as per requirement. Thank you. But it would be much better, if any pop-up will appear here in Batch column to select the batches out of many. In pop-up if we type any starting letter then only those batches should appear which contains that typed letter

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-18 Thread Ashish Kumar
Thanks Vaibhav Bhai!!! Regards Ashish -- 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 titl

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-18 Thread Vaibhav Joshi
Good one ashish bhai, i remeber this you posted long ago too... On Sun, Jan 18, 2015 at 9:16 AM, Ashish Bhalara wrote: > Thanks Mr.Ashish Kumar, your sharing file of ListPicker is very useful for > me. :) > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-18 Thread Ashish Kumar
Welcome. Regards Ashish -- 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 Hel

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-17 Thread Ashish Bhalara
Thanks Mr.Ashish Kumar, your sharing file of ListPicker is very useful for me. :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sat, Jan 17, 2015 at 9:32 PM, Ashish Kumar wrote: > PFA > > Regards >

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-17 Thread Pravin Gunjal
don On Sat, Jan 17, 2015 at 5:55 PM, Ashish Kumar wrote: > Share the password ...? > > -- > 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)

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-17 Thread Ashish Kumar
Share the password ...? -- 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

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-17 Thread Pravin Gunjal
It's *Lot Number (column D)* On Sat, Jan 17, 2015 at 5:28 PM, Ashish Kumar wrote: > which field you want to pick as batch in GGRN sheet from Batch sheet. > > -- > 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 th

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

2015-01-17 Thread Ashish Kumar
which field you want to pick as batch in GGRN sheet from Batch sheet. -- 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 threa