$$Excel-Macros$$ Problem in excel

2011-01-30 Thread Jitender kumar
Dear Sir I have problem with excel file.Please provide the solution.(See attachment) Regards Jitender -- -- 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 Umesh Dev
Hi jitender, Find the enclsd sheet if it could help. Regards Umesh On Sun, Jan 30, 2011 at 1:55 PM, Jitender kumar jk9779771...@gmail.comwrote: Dear Sir I have problem with excel file.Please provide the solution.(See attachment) Regards Jitender --

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 jk9779771...@gmail.comwrote: Dear Sir I have problem with excel file.Please provide the solution.(See attachment) Regards Jitender --

$$Excel-Macros$$ Please help

2011-01-30 Thread sudhir kumar
Dear Experts please hep me for a formula which worked on color. please see attachment. -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * --

Re: $$Excel-Macros$$ removing multiple data and converting column into row

2011-01-30 Thread Umesh Dev
Hi I hope the enclsd sheet will help you. Regards Umesh Dev On Sun, Jan 30, 2011 at 12:40 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi Vikalp, Please refer the attached excel for solution. I have automated everything in formula and you need not to do any manual input in

Re: $$Excel-Macros$$ Please help

2011-01-30 Thread ashish koul
check the attachment On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Experts please hep me for a formula which worked on color. please see attachment. -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is

Re: $$Excel-Macros$$ Please help

2011-01-30 Thread Aamir Shahzad
Result attached Aamir Shahzad On Sat, Jan 29, 2011 at 9:13 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Experts Please help see my attachement and help me. thanking you -- Sudhir Verma Asstt. Mngr. A/c's P think Before you print * * ** Life is Very beautiful !!! * *

$$Excel-Macros$$ Cell Validation using VBA

2011-01-30 Thread Rob
Can anyone help please? I have tried to apply the following VBA code in order to establish a validation within a particular cell that will measure the data entry against date values in other cells: With Selection.Validation .Delete .Add Type:=xlValidateCustom,

Re: $$Excel-Macros$$ Please help

2011-01-30 Thread Umesh Dev
Hi sudhir, Click *Conditional formatting* tab -Select *New Rule* - Select *Format only cells that contain* - click on *Format* and choose the color. Regards Umesh Dev On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Experts please hep me for a formula

$$Excel-Macros$$ Re: Weekday only from column to rows!

2011-01-30 Thread Prakash Gusain
this is done plz ignore -- -- 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 @