Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-17 Thread Vaibhav Joshi
Hi Check conditional format set in sheet.. First select Cell A1, then conditional formting and Manage Rules... Cheers!! On Fri, Jul 18, 2014 at 12:51 AM, Ahmed Emam wrote: > That' what i mean but i need t know how to do it because i will apply it > to other file > > thanks > > > On Thu, Ju

$$Excel-Macros$$ Fwd: R Shop Data

2014-07-17 Thread my excel
Sir, i sent attached file of my friend ration shop & pls see out put data he wanted a macro to generate output data pls help regards: Veerendra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https:

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

2014-07-17 Thread renuka chari
Dear sir, i was prepared a macro for autofilter the range based on column a1 in unique values and paste this range into sheet2 side by side in this i have succed in the autofilter the range data but failed to copy this data into sheet2 side by side i think may be some logic was missing in secoun

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

2014-07-17 Thread Pramod Singh
What is error going on..Completely explain On Fri, Jul 18, 2014 at 2:00 AM, Renukachari Kasee wrote: > Dear Experts please help me in this regard. > > my macro was not working properly > > please help me...its urgent > > > > > > > > *(¨`•.•´¨) Always`•.¸(¨`•.•´¨) Keep(¨`•.•´¨)¸.•´ Smiling!!

$$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

2014-07-17 Thread Renukachari Kasee
Dear Experts please help me in this regard. my macro was not working properly please help me...its urgent *(¨`•.•´¨) Always`•.¸(¨`•.•´¨) Keep(¨`•.•´¨)¸.•´ Smiling!!`•.¸.•´Thanks & Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* *P Let us do

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-17 Thread Ahmed Emam
That' what i mean but i need t know how to do it because i will apply it to other file thanks On Thu, Jul 17, 2014 at 10:03 AM, Vaibhav Joshi wrote: > Check this!! > > Cheers! > > > On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam wrote: > >> I have an excel sheet and i want some cells to be highl

$$Excel-Macros$$ Urgent required Java/ UI Developer - Dublin, OH

2014-07-17 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com * *Position: Java/UI developerLocation: Dublin, OHDuration: 6+ Months* Experience: 5 to 8 years Positions: 10 JD: Technical Skills: oFront End / JavaScript / HTML5 / CSS 3/ Angular oJavaScript libraries like Angular or Backbone oCSS3

Re: $$Excel-Macros$$ Error on saving the excel file

2014-07-17 Thread Vaibhav Joshi
in which environment you are using excel file? what is version of excel? On Thu, Jul 17, 2014 at 5:11 PM, Pravin Gunjal wrote: > Hello, > > I am getting the following/attached error, while saving the attached excel > file. > > [image: Inline image 1] > > What would have been the reason behind i

Re: $$Excel-Macros$$ Transpose column to row basis column heading

2014-07-17 Thread Vaibhav Joshi
Ok, here you go..From First sheet press Blue button to run Macro.. Cheers!! On Thu, Jul 17, 2014 at 5:01 PM, Prakash Gusain wrote: > Yes they are static > > > On Thursday, July 17, 2014 3:21:37 PM UTC+5:30, Vabz wrote: > >> Is header in Raw data static? >> >> >> On Wed, Jul 16, 2014 at 5:22 P

Re: $$Excel-Macros$$ Transpose column to row basis column heading

2014-07-17 Thread Prakash Gusain
Yes they are static On Thursday, July 17, 2014 3:21:37 PM UTC+5:30, Vabz wrote: > > Is header in Raw data static? > > > On Wed, Jul 16, 2014 at 5:22 PM, Prakash Gusain > wrote: > >> Hi All, >> >> Attached file has two tabs (Raw Data & OutCome). What I am trying to >> achieve is transposing colum

Re: $$Excel-Macros$$ Transpose column to row basis column heading

2014-07-17 Thread Vaibhav Joshi
Is header in Raw data static? On Wed, Jul 16, 2014 at 5:22 PM, Prakash Gusain wrote: > Hi All, > > Attached file has two tabs (Raw Data & OutCome). What I am trying to > achieve is transposing column F & G of the Raw Data onto OutCome tab. The > catch is to transpose basis the role which is lis

$$Excel-Macros$$ VBA Query

2014-07-17 Thread Satendra kumar
Hi All, Please solve this query! Write a vba code to populate the number greater than 5 in red color and less than 5 in green color -- Thanks & Regards Satendra Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook p

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-17 Thread Vaibhav Joshi
Check this!! Cheers! On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam wrote: > I have an excel sheet and i want some cells to be highlighted by some > colors if other 3 cells filled by text. > please see the attached example: > > What i mean that Cell A to be highlighted Yellow if Cell A1 filled b