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

2015-04-01 Thread Vaibhav Joshi
cheers!! On Wed, Apr 1, 2015 at 8:52 PM, bobengler wrote: > Thank you. That worked. I had (and did again) copied the 2 formulas to > Notepad and then pasted them into the formula part of the Highlight rules > in my working xlsx sheets but it didn't work correctly. I then pulled in > your new xls

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

2015-04-01 Thread Vaibhav Joshi
check this... On Wed, Apr 1, 2015 at 8:45 PM, Prabhu Pinky wrote: > Experts, > > Any update on my below query.. > On 31-Mar-2015 5:45 PM, "Prabhu Pinky" wrote: > >> Hi experts, >> >> Please share vba code to copy outlook mails subject name, sender name, >> Date into excel sheet. >> >> Code has

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

2015-04-01 Thread bobengler
Thank you. That worked. I had (and did again) copied the 2 formulas to Notepad and then pasted them into the formula part of the Highlight rules in my working  xlsx sheets but it didn't work correctly. I then pulled in your new xlsx and copied my data from my sheet to your sheet, changed the rang

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

2015-04-01 Thread Prabhu Pinky
Experts, Any update on my below query.. On 31-Mar-2015 5:45 PM, "Prabhu Pinky" wrote: > 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. Fo

$$Excel-Macros$$ Find Color Details using search box output in form (UI editor add-in)

2015-04-01 Thread myxlguru
Sir, need form to show result from colordata.xlsx (auto search in closed workbook) when i put colorcode in (color code.xlsm) box result will display on 1 form pls solve my friend query sir thanks -- 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)

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

2015-04-01 Thread Vaibhav Joshi
check sheet after updating formula... On Wed, Apr 1, 2015 at 12:49 PM, Vaibhav Joshi wrote: > HI > > Note cell range & dollar sign, it is $B$1:$B1<>$B$2:$B2 > > > > On Tue, Mar 31, 2015 at 10:42 PM, bobengler > wrote: > >> Here is a test of after I added the 2 rules. Can you see if I missed a >

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

2015-04-01 Thread Vaibhav Joshi
HI Note cell range & dollar sign, it is $B$1:$B1<>$B$2:$B2 On Tue, Mar 31, 2015 at 10:42 PM, bobengler wrote: > Here is a test of after I added the 2 rules. Can you see if I missed a > step? > > Thanks, > > Bob > > > -- > *From:* Vaibhav Joshi > *To:* "excel-mac