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 kumar.ashish...@gmail.com wrote: Thanks. Pravin ...!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

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 kumar.ashish...@gmail.com 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

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.

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,

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

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,

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 isk1...@gmail.com wrote: Good Morning, It's fantastic... On Mon, Jan 19, 2015 at 9:13 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Dear Pravin jee PFA Regards Ashish -- Are you =EXP(E:RT) or

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 kumar.ashish...@gmail.com 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

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

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

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 ashishbhalar...@gmail.com 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

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

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 kumar.ashish...@gmail.com

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

2015-01-17 Thread Pravin Gunjal
*Hi, Can I expect a reply from anyone..* On Friday, January 16, 2015 at 4:13:20 PM UTC+5:30, Pravin Gunjal wrote: Hi, I have attached an excel file contains 4 sheets.. I am entering mu data in fourth sheet viz. GRRN Entry -which has connected with first three sheets. *What I want is:*

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

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 kumar.ashish...@gmail.com 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

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

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 kumar.ashish...@gmail.com 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