Fw: $$Excel-Macros$$ Help required

2011-10-12 Thread suryaprasad . bv
Hi Guys can anyone help me on this please Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 04:52:12 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help required Hi G

Re: $$Excel-Macros$$ Connect 2 sheets .....

2011-10-04 Thread suryaprasad . bv
Yes apart from this thanks a ton to Ayush for his continous support... U rock ayush Sent from BlackBerry® on Airtel -Original Message- From: shashank bhosle Sender: excel-macros@googlegroups.com Date: Wed, 5 Oct 2011 11:17:30 To: excel-macros@googlegroups.com Reply-To: excel-macros@goo

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

2011-10-01 Thread suryaprasad . bv
Hip Hip Hurry.. For sure you deserve that NOORAIN u rock dear ...keep rocking way to go in this group Thanks Surya Sent from BlackBerry® on Airtel -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Sun, 2 Oct 2011 00:43:24 To: excel-macros Reply-To: exc

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

2011-09-05 Thread suryaprasad . bv
Congratulations BRO u rock :-) Sent from BlackBerry® on Airtel -Original Message- From: Venkat CV Sender: excel-macros@googlegroups.com Date: Tue, 6 Sep 2011 10:43:07 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes

2011-09-05 Thread suryaprasad . bv
Hi all, Can anyone help me on this?? Regards Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent Date: Mon, 5 Sep 2011 17:10:47 To: Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single cas

Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes

2011-09-05 Thread suryaprasad . bv
Hi Noorain, Please help Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent Date: Mon, 5 Sep 2011 17:10:47 To: Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single case in the code,

Re: $$Excel-Macros$$ **Pivot Table Doubt**

2011-08-31 Thread suryaprasad . bv
Can you post the pivoted file plz ? Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Prabhu Sender: excel-macros@googlegroups.com Date: Wed, 31 Aug 2011 12:28:10 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ **Pivot Table Doubt** Hi Friend

$$Excel-Macros$$ How to load data into Combo box in user form

2011-08-30 Thread Suryaprasad
Hi All, Attached is the sheet where i need the list of the countries to be added to the combo box Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad --

Re: $$Excel-Macros$$ User form

2011-08-30 Thread Suryaprasad
*Best Regards,* > *Venkat * > *Chennai* > * > * > * > * > > On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad > wrote: > >> Hi , >> >> Please see my excel spread sheet i need the userform as POP see the chail >> mail >> >> Thanks >>

Re: $$Excel-Macros$$ User form

2011-08-30 Thread Suryaprasad
Sub > > *From:* Suryaprasad > *Sent:* Tuesday, August 30, 2011 7:42 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ User form > > Hi All, > > Need a small help , i need to get a pop up of the user form when my excel > is o

$$Excel-Macros$$ User form

2011-08-30 Thread Suryaprasad
Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

$$Excel-Macros$$ Need a Help in Macro

2011-08-23 Thread Suryaprasad
Hi Rajan, Thanks for the Macro, but i need somethig like this : I have 5 TAB's in the first TAB named with Sheet1 i have Control as Sheet2 the point here is once i work on my sheet1 then i need to go to Sheet2 so i have placed a control as sheet2 (something like hyperlink)and once i click on shee

Re: $$Excel-Macros$$ Need help in maro

2011-08-22 Thread suryaprasad . bv
plication.Caller).TextFrame.Characters.Text Then Sheets(i).Visible = False End If Next Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub On Tue, Aug 23, 2011 at 10:56 AM, Suryaprasad wrote: > Hi All, > > I was trying to write a macro which is not working well, a

$$Excel-Macros$$ Need help in maro

2011-08-22 Thread Suryaprasad
Hi All, I was trying to write a macro which is not working well, attached is the sheet where is require a small code the below is the what i require: I have a main sheet which is assgined with controls and i have 5 TABS , what i want is when i click on the first control named with Sheet1 in the m

$$Excel-Macros$$ Valuable Info

2011-07-03 Thread Suryaprasad
Hi, Register on the below link (FETISE) and get a instant 500/- rs off on any purchase of the product ..its really good and once after registered please refer to your friends and get paid and own your gifts. http://www.fetise.com/men/register2.php?refcode=81TJ5KG0G3 Thank you Surya -- ---

Fwd: $$Excel-Macros$$ Generate random numbers based on number given in a cell

2011-05-30 Thread Suryaprasad
Hi Ayush, Can you please help on the below Thanks prasad -- Forwarded message -- From: Suryaprasad Date: Sun, May 29, 2011 at 7:59 AM Subject: $$Excel-Macros$$ Generate random numbers based on number given in a cell To: excel-macros@googlegroups.com Hi Experts, Need a

$$Excel-Macros$$ Generate random numbers based on number given in a cell

2011-05-28 Thread Suryaprasad
Hi Experts, Need a formula or a code for the sample sheet Attached, this is about the generating a random based numbers given in spread sheet Thanks Prasad -- -- Some important links for excel users: 1. Follow us on

$$Excel-Macros$$ Countif Problem

2011-04-03 Thread Suryaprasad
Hi Team / Ayush, Need a formula about a countif criteria See the attachment and please do the need full Regards prasad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Problem in excel

2011-01-30 Thread Suryaprasad
Here you go with pivot..! On Sun, Jan 30, 2011 at 1:55 PM, Jitender kumar wrote: > Dear Sir > > I have problem with excel file.Please provide the solution.(See attachment) > > Regards > > Jitender > > -- > > -- > Some

Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey

2011-01-04 Thread Suryaprasad
Congrats Dilip On Tue, Jan 4, 2011 at 7:37 PM, sharad gupta wrote: > Hi Dilip Sir, > Congratulations to you . That is good news on new year 2011. > > sharad gupta > On Mon, Jan 3, 2011 at 7:32 PM, Manoj kumar < > manoj.vishwakarma...@gmail.com> wrote: > >> Congrats Dilip... >> >> >> Best Regar

Re: $$Excel-Macros$$ Is it a Challenge!!!!!

2010-12-17 Thread Suryaprasad
As you are aware that lots of emails cannot be tracked and replied soon it doesnot mean that is a challenge..! On Fri, Dec 17, 2010 at 10:27 AM, Deepak Rawat wrote: > Hi i have posted this problem two times but got no reply > Is it a challenge!!! > > Dear All > > I am designing a user form but n

Re: $$Excel-Macros$$ Ctrl + space bar

2010-08-04 Thread Suryaprasad
When you are facing such a prblm then y cant u disable the VBA option? On Wed, Aug 4, 2010 at 10:43 AM, Dave Bonallack wrote: > Hi, > I never use Ctrl+Space. Didn't know about it. When the list of names > appears, just select the one you want by double-clicking on it > Regards - Dave. > > > Date:

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

2010-05-24 Thread Suryaprasad
Hey, Thats wonderfull. Ayush, You are the best. Thanks Surya On Mon, May 24, 2010 at 9:00 AM, Ayush wrote: > Dear Group Members, > > Finally, after long time we have achieved a milestone of 7000 > members. > > I would use this moment to thank each one of you for your contribution > to the gr

$$Excel-Macros$$ Understanding & Implementation

2010-04-16 Thread Suryaprasad
Hi All, To my observations from the past, we have been 99 % sucessfull in answering all the replies, but with some delays as some of us asking for a attachment & few of us asking to clarify the question again, my understanding of correct procedure to help in one single short way would be below.

Re: $$Excel-Macros$$ Urgent Help

2010-04-08 Thread Suryaprasad
Hey Sudhir, No need of a Look upOnly thing u can do a formulae for Transpose is required..please find the attachement. Surya On Tue, Apr 6, 2010 at 7:44 PM, sudhir kumar wrote: > *Hi friends* > ** > *Please help me urgent* > *problem of Hlookup formula in attached file. > * > -- > Sudhir V

Re: $$Excel-Macros$$ Macro

2010-03-24 Thread Suryaprasad
Hi Sreejith, Can we have a Sample File for our reference. Thanks Surya On Tue, Mar 23, 2010 at 6:05 PM, sreejith k.s wrote: > Hi Guys, > > I need help from you guys, > > I have 18 files in which 9 files come in same category and the rest in > another category say Set 1 and Set 2. > Set 1 contai

Re: $$Excel-Macros$$ DD/MM/YYYY Excel Query

2010-03-10 Thread Suryaprasad
Hi Sachin, Hope this formula works for you! If the Actual data is in ColA & Row 1 then the formula in red shud be entered in ColB&Row1.. =RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4) Thanks Surya On Mon, Mar 8, 2010 at 4:22 PM, sachinp1...@googlemail.com < sachinp1...@googlemail.com> wrote: >

$$Excel-Macros$$ Tip of the Day for 11th June 09

2009-06-10 Thread Suryaprasad
Hi All, Folks thanks for the wonderfull support for getting out with good postings and tips hope all will continue in the same fashion and keep this environment alive. *Question:* *If you have comments in a scrumbled all over the spread sheet ( Not in order) but you want to delete the comments

$$Excel-Macros$$ Re: Formula needed

2009-05-27 Thread Suryaprasad
Venkat, can you post us a sample file..so that it would be easier to us to help out...? On Wed, May 27, 2009 at 9:19 AM, venkat sudhakar wrote: > Dear Friends, > > I need a formula for my work. > > There will be 2 Excel sheets. > > In First Sheet there will be 2 Columns > > In First column there

$$Excel-Macros$$ Re: Help required on Condition or Formula.

2009-05-26 Thread Suryaprasad
Pooja, I hope you are looking for this one..(colored in red) this was calculated as per the length..so you can adjust the same per your convience... Good Luck Cheers Surya On Tue, May 26, 2009 at 11:31 AM, Pooja Sharma wrote: > Hi All, > > I need a help, with a condition in which I have to mat