Re: $$Excel-Macros$$ Please help on the formula

2010-12-24 Thread poojari sreevijay
> > Hi Noorian/ Team, > I got succeded in retrieving data by using dr as branch ( used indirect function only )but failed when trying to give sr as branch . could any one can fix the issue.. only by using indirect function only... it should retrieve data based on branch . Please find the atta

$$Excel-Macros$$ Help on Advance Formula

2010-12-24 Thread Chandra Shekar
Hello Team, How to get unique value based on two columns in the attached file Regards, Chandra Shekar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.

$$Excel-Macros$$ how to attach excel sheet to this blog posts

2010-12-24 Thread renuka chari
how to attach excel sheet to this blog posts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.li

$$Excel-Macros$$ Wishing you all Merry Christmas ! ..

2010-12-24 Thread ashish koul
Wishing you all Merry Christmas ! .. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com *akoul*.wordpress.com My Linkedin Profile P Before printing, think about the environment. --

RE: $$Excel-Macros$$ Need Excel Formula or VBA Function to Solve the Query.

2010-12-24 Thread Daniel
Hi, See attached file. The result cells are painted yellow. The formulas are array formulas (you have to validate them with Ctrl+Shift+Enter instead of “Enter”) Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de amrahs k Envoyé : dimanche

RE: $$Excel-Macros$$ Tab name changes, macro references old name

2010-12-24 Thread Daniel
Can't you use the sheet codename instead ? HTH Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Pete Envoyé : vendredi 10 décembre 2010 20:49 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Tab name changes, macro refer

Re: $$Excel-Macros$$ Please help on the formula

2010-12-24 Thread anil panchal
Hi Noorain, Here we use only vlookup i am worng or right, On Fri, Dec 24, 2010 at 5:00 PM, NOORAIN ANSARI wrote: > Dear Poojari, > > Please see attachments.. > > Thanks, > Noorain Ansari > > On Fri, Dec 24, 2010 at 12:24 AM, poojari sreevijay < > psreevi...@gmail.com> wrote: > >> Hi Team, >

Re: $$Excel-Macros$$ Please help on the formula

2010-12-24 Thread NOORAIN ANSARI
Dear Poojari, Please see attachments.. Thanks, Noorain Ansari On Fri, Dec 24, 2010 at 12:24 AM, poojari sreevijay wrote: > Hi Team, > > Please advise on the formula in H.O Sheet .. > > I am unable to get the data in B4. > > > > -- > psreevi...@gmail.com > > -- > > --

Re: $$Excel-Macros$$ Need to be able to find duplicates before a space

2010-12-24 Thread Ms-Exl-Learner .
In addition to the below the cursor (Activecell) should be in B2 cell. --- Ms.Exl.Learner --- On 12/23/10, siti Vi wrote: > select the range of your Numbers > for example: B2:B200 > you can apply a conditional formatting on that range > > the condition FOR

Re: $$Excel-Macros$$ Merry Christmas & Happy new year...

2010-12-24 Thread lucky singh
Thanx a lot venkat does any one has more of it... Regards, Lucky On Fri, Dec 24, 2010 at 4:17 PM, Venkat wrote: > Hi Lucky, > > Find attached > > Best Regards, > > Venkat Cv > > On Fri, Dec 24, 2010 at 11:15 AM, lucky singh wrote: > >> >> Hi Guys, >> >> Do anyone has a excel greet

Re: $$Excel-Macros$$ Recovery plz

2010-12-24 Thread Venkat
Dear Saijt, Find below Link&Download Software &Install,It may Help you... http://www.excel-tool.com/vbarecovery.html *Best Regards,* ** *Venkat CV* On Thu, Dec 23, 2010 at 12:42 PM, Vikas Chouhan wrote: > send ur file > > On Tue, Dec 21, 2010 at 10:45 PM, SAJID MEMON wrote: > >> Dear All, >>

Re: $$Excel-Macros$$ how to use the macros in a closed book

2010-12-24 Thread chalakrit sawetluk
sub Auto_close() end sub 2010/12/22 Rajesh K R > Hi Experts > > Is it possible to use a macro in a workbook to another workbook when > that book having the macro is closed.If possible pls let me know how > to do it. > > Regards > Rajesh Kainikkara > > -- > > -

$$Excel-Macros$$ Please help on the formula

2010-12-24 Thread poojari sreevijay
Hi Team, Please advise on the formula in H.O Sheet .. I am unable to get the data in B4. -- psreevi...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : h

$$Excel-Macros$$ Merry Christmas & Happy new year...

2010-12-24 Thread lucky singh
Hi Guys, Do anyone has a excel greetings for Christmas or new year... plz do forward. Thanx in advance, Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

$$Excel-Macros$$ Question about excel

2010-12-24 Thread vinod rao
Hello, I have details in summary sheet and i want the details posted to the respective sheet also. Do we have any method to have details posted to the respective sheets. Example in summary tab i have west region details and the entire row of west should also be in West sheet also is there any m

Re: $$Excel-Macros$$

2010-12-24 Thread kiran Kancharla
Simply u can use Find and replace. On Thu, Dec 23, 2010 at 3:48 PM, Rajiv Kumar wrote: > Dear sir > > how can sum with rupees simbol. > > It yes then please give me tips. Awating your positive replay… > > > > > Raj > > -- > ---