$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-31 Thread Mandeep Baluja
dont type -- manually just copy it and replace otherwise replace will not work. On Tuesday, March 31, 2015 at 12:22:54 AM UTC+5:30, Bill Q wrote: Thanks, but I must be doing something wrong - becuase it isn;t working for me. On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote:

$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-31 Thread Mandeep Baluja
Copy your double code in replace box don't type it it will get easily replaced. On Tuesday, March 31, 2015 at 12:22:54 AM UTC+5:30, Bill Q wrote: Thanks, but I must be doing something wrong - becuase it isn;t working for me. On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote:

$$Excel-Macros$$ Re: How to check a field and change highlight color if the cell value changes

2015-03-31 Thread Mandeep Baluja
Try this file !!! Regards, Mandeep baluja On Tuesday, March 31, 2015 at 7:53:09 AM UTC+5:30, Bob Engler wrote:

Re: $$Excel-Macros$$ Formula required

2015-03-31 Thread Vaibhav Joshi
Check this... On Tue, Mar 31, 2015 at 12:43 PM, Dhaval Shah todhavals...@gmail.com wrote: PFA Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ How to check a field and change highlight color if the cell value changes

2015-03-31 Thread Vaibhav Joshi
Hi Bob, Check attachment, Copy formula from G2 Select A2 to D12 ( or larger range) goto conditional formatting, select manage rules select new rule, after that select use formula to determine which cells to format..paste formula, click format select color you want to give... After that Copy

Re: $$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-31 Thread Vaibhav Joshi
character which you see may not be the same which you type, press F2 copy characters then you can do Find replace copied character with unique character like underscore or so after that goto data text to column.. On Tue, Mar 31, 2015 at 12:22 AM, Bill Q ronsmith...@gmail.com wrote: Thanks,

$$Excel-Macros$$ Formula required

2015-03-31 Thread Dhaval Shah
PFA Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* -- 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://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2015-03-31 Thread Vaibhav Joshi
Hi Bob, Check attachment, Copy formula from G2 Select A2 to D12 ( or larger range) goto conditional formatting, select manage rules select new rule, after that select use formula to determine which cells to format..paste formula, click format select color you want to give... After that Copy

$$Excel-Macros$$ Calender Control

2015-03-31 Thread Rakesh kumar
Hi, I am using Excel 2010 and I want to use Date Picker(Calender) in Excel sheet. but Calender control is not showing on Additional Control. I tried to add this using More Control and Refrences, but there is no calender control available. In Excel 2007 i have used calender But 2010 version am

Re: $$Excel-Macros$$ Calender Control

2015-03-31 Thread Pramod Singh
Bro u need install Microsoft Activex control go in activex.microsoft.com and click control. Pramod On 31 Mar 2015 16:26, Rakesh kumar rakesh.apt...@gmail.com wrote: Hi, I am using Excel 2010 and I want to use Date Picker(Calender) in Excel sheet. but Calender control is not showing

$$Excel-Macros$$ Macro to copy outlook mail

2015-03-31 Thread Prabhu Pinky
Hi experts, Please share vba code to copy outlook mails subject name, sender name, Date into excel sheet. Code has to copy the above fields from entire mail from the selected folder in outlook. Folder selection should be user option. For ex: if i run the code it has to ask the folder from which

Re: $$Excel-Macros$$ How to check a field and change highlight color if the cell value changes

2015-03-31 Thread Sunil Kumar Yadav
Great Sir Thanks, Sunil Kr. Yadav Sent from my ASUS On 31-Mar-2015 1:36 pm, Vaibhav Joshi v...@vabs.in wrote: Hi Bob, Check attachment, Copy formula from G2 Select A2 to D12 ( or larger range) goto conditional formatting, select manage rules select new rule, after that select use

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2015-03-31 Thread bobengler
Here is a test of after I added the 2 rules. Can you see if I missed a step? Thanks, Bob   From: Vaibhav Joshi v...@vabs.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Tuesday, March 31, 2015 4:02 AM Subject: Re: $$Excel-Macros$$ Re: How to append row from 1