$$Excel-Macros$$ Help

2011-10-17 Thread suryaprasad.bv
Hi All, Can anyone help me on this by using index function. I have a drop down where i click on the required and i need to get the subset details of those drop down Thanks Prasad -- -- Some important links for exce

$$Excel-Macros$$ Re: Error While opening excel File

2009-05-13 Thread Suryaprasad.bv
Yogendra, To get back the original file there is a Software already installed in the Office - just go to - Programs- Microsoft office - Microsoft office tools - Microsoft application recovery tools then wait & see On Wed, May 13, 2009 at 12:23 PM, Yogendra Joshi wrote: > Dear All, > > I am get

$$Excel-Macros$$ Re: Insert ListBox into Cell

2009-05-07 Thread Suryaprasad.bv
Hi Walid, Go to Data - Validation in the option button click as List -- Mention the names you need and close. All the action will be applied on the selection of cell. Cheers Surya On Thu, May 7, 2009 at 12:39 PM, Mr Walid Zahran wrote: > > Hi Group; > > I'm new to MS EXCEL AND VBA MACROS. I w

$$Excel-Macros$$ Re: Help on Spelling correction on excel

2009-05-06 Thread Suryaprasad.bv
Hi Maulik, Just press key F7 after completion of sentence - which is similarly for word where you can replace or spell check. Cheers Surya On Wed, May 6, 2009 at 12:11 PM, maulik desai wrote: > Hi All, > > I want some tool or any idea that how we can change or correct the spelling > which we wr

$$Excel-Macros$$ Re: { } -his is a function?

2009-05-01 Thread Suryaprasad.bv
Hi dear, { - is a formula which occupys the array instead of a cell - the basics to use the formula is you need to type the formula and press Ctrl + Shift + Enter by selecting the particular array. Cheers Surya On Fri, May 1, 2009 at 2:16 PM, Yu wrote: > > Hi all, > > I've been programming V

$$Excel-Macros$$ Re: Index and Offset Formula Help

2009-04-22 Thread Suryaprasad.bv
where is it attached..? On Thu, Apr 23, 2009 at 2:57 AM, Fabio_XL_Master wrote: > > Hi, > > other possible solution is attached. Using offset and Array formula. > > > Fabio > > > > > > --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Color Conditional Formatting

2009-04-17 Thread Suryaprasad.bv
Thanks man...! Good work On Wed, Apr 15, 2009 at 8:07 PM, Harmeet Singh wrote: > Hi Surya, > > See attached file. > One suggetion, it would be easy to apply conditional formatting if you > change the format for column A. > > On Wed, Apr 15, 2009 at 12:59 PM, Suryaprasad.bv

$$Excel-Macros$$ Color Conditional Formatting

2009-04-15 Thread Suryaprasad.bv
Hi Guys, Can any one help me on the conditional formatting . Cheers Surya --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Tex

$$Excel-Macros$$ Re: Cell Validation - Conditional

2009-04-14 Thread Suryaprasad.bv
Prashant, Can you post me a sample file so that i can help you out Cheers Surya On Tue, Apr 14, 2009 at 12:16 PM, Prashant Pednekar wrote: > Hi All > > here my doubt is > The Validation is not having constraint, > i.e. afte entering one product and specification, if i am again changing > the