Re: $$Excel-Macros$$ Help required in conditional formatting

Dear Manoj, As requested, please find below the process. Assume you want to do conditional formatting in entire row 2, if it has some specific text i.e, (DILIpandey) in column B. so if B2 has value as DILIpandey, then entire row will change to Red. Steps:- 1) Select the entire row # 2, by

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

hi ashish good work Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jan 14, 2010 at 6:52 PM, kvc praveen kumar pkkara...@gmail.com wrote: Thanks Vinod.. Glad that it was helpful!! On Thu, Jan 14, 2010 at 5:51

$$Excel-Macros$$ looping by timeing

sir how can stop a loop by time in excel vb code -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and

Re: $$Excel-Macros$$ Help required

Dear Abhi, Your source data is not aligned properly. For working with charts, you need to have data in structured manner. See if you can work with source data and remove extra rows/columns in between. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744

$$Excel-Macros$$ Urgent: Consolidate CSV and have a Unique Identifier

Hi All, I would be grateful if you guide me to how I could consolidate .csv files and be able to separate or distinguish between the rows by the different files being consolidated. Eg. .csv File 1: Column A 1 1 1 .csv File 2: Column A 2 2 2 Consolidated .csv 1

$$Excel-Macros$$ how to use fillcolor for an condition

when a100 ,i need fill the box with green color similarly when a100,i need to fill the box with red colour can anyhelp on thisss thanks ashok -- -- Some important links for excel users: 1. Follow us in TWITTER

Re: $$Excel-Macros$$ how to use fillcolor for an condition

Attached file would help... Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Jan 15, 2010 at 3:06 PM, Ashok Renga ashokrenga2...@gmail.comwrote: when a100 ,i need fill the box with green color similarly when a100,i need to fill the box with red colour can

$$Excel-Macros$$ HELP needed for macro

HI VBA GURUS, I know excel pretty well,But my knowledge in VBA is big zero.I have two excel work sheets (SAP PHY),both are arranged as table *one common field (MATERIAL) *available in both sheets ,what I required* is a macro* that brings *quantity* from w.sheet PHY

$$Excel-Macros$$ Help with Hyperion Addin!!!!

Hi, I have a Hyperion Addin installed in my system, To give a background about the system. Hyperion is a financial management software. Its Add- in helps the users to retrieve data of particular accounts on the excelsheet according to parameters set. Problem: The Add-in is like a menu on the

Re: $$Excel-Macros$$ how to use fillcolor for an condition

its quite simple use the conditional format. On Fri, Jan 15, 2010 at 10:29 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Attached file would help... Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Jan 15, 2010 at 3:06 PM, Ashok Renga