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 v...@vabs.in 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 bobeng...@bellsouth.net wrote: Here is a test of after I added the 2 rules. Can

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 bobeng...@bellsouth.net 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

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 prabhupin...@gmail.com 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

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

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 prabhupin...@gmail.com wrote: Experts, Any update on my below query.. On 31-Mar-2015 5:45 PM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi experts, Please share vba code to copy outlook mails subject name, sender name, Date

$$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

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 bobeng...@bellsouth.net 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