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$$ AssignMacro to Shape - for a Userform

2015-01-17 Thread sswcharlie
Hi Trying to get a macro assigned to open a userform. The macro does not show in Macro Menu. Have tried some VBA in 'Workbook' visual. (off the net) Sub... UserForm1.Show EndSub but userform still does not show. How do I get the userform1 etc to show in Macro Menu ? Thanks Charlie --

Re: $$Excel-Macros$$

2015-01-17 Thread Shrinivas Shevde
Dear Paul Yesterday I tried and now problem is solve but still I could not loacte the problem its got solve just by luck. Regards Shrinivas On Fri, Jan 16, 2015 at 10:25 AM, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear Paul Very very thanks for reply. I will follow the steps and wil

$$Excel-Macros$$ sum values with col/row criteria

2015-01-17 Thread MLT
Here's one: In A1:A7: 1st 3rd 1st 2nd 3rd In B1:E1: 3, 2, 5, 4 In C4: cat In E7: dog I want to make a formula that will count the number of cells in a range that contain a string (any string), but that also falls under row and column criteria. For example, if the column criteria is 3rd and

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