Re: $$Excel-Macros$$ how to insert logo in excel print

Hi, Use this link: http://www.techrepublic.com/blog/msoffice/print-a-logo-in-an-excel-header/216 Regards, Andy On Thu, Feb 7, 2013 at 10:22 AM, excel lerner wrote: > Dear Experts > > I want to insert my company logo in Print by default.I tried to insert > through custom header.But it applies f

Re: $$Excel-Macros$$ Fwd:

hey Ayush , Ban this user. Warm Regards, Gawli Anil On Thu, Feb 7, 2013 at 4:47 AM, mayank upadhyay wrote: > http://www.antonellacimatti.it/1cw3bk.php?s=lf > > -- > 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

$$Excel-Macros$$ Fwd:

http://www.antonellacimatti.it/1cw3bk.php?s=lf -- 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 RULES 1) Use concise, accurate thread titles. Poor thread t

$$Excel-Macros$$ Re: Need exporting help for Records more than 65000 records in Access to Excel

Export the file out of the database in a txt format, then open excel, go to data, get external data from text. It will take you through the steps and allows you to import more than 65000 records. On Sunday, February 3, 2013 4:46:56 AM UTC-5, rekha siri wrote: > hi Group, > > Need your experti

Re: $$Excel-Macros$$ Match a Word in a cell using Macros

Hi, Instead of Macro, you can try using match or search function. , On Wed, Feb 6, 2013 at 7:39 PM, Santhosh Kumar M K wrote: > Hi Friends, > > Need a help to create macro in a "Data" tab where it can recongnize a word > either by first/middle/last name if not with full name. > > for ex - "SHANG

Re: $$Excel-Macros$$ Match a Word in a cell using Macros

Use this function Function WLOOKUP(strText As String, rng As Range) As String Dim lng As Long, lngI As Long On Error Resume Next For lng = LBound(Split(strText, " ")) To UBound(Split(strText, " ")) lngI = Application.Match(Split(strText, " ")(lng), rng, 0) If lngI <> 0

Re: $$Excel-Macros$$ Re: Macro - To split each spreadsheets as a new workbook

Hi Shekhar, Thanks for your support. File name should be like "Account Tracker tab name". Regards, Santhosh On Fri, Feb 1, 2013 at 11:57 PM, Shekhar wrote: > Hi Santhosh, > > Please find attached workbook and let me know if it works. > > > Thanks and regards, > Shekhar > > On Friday, 1 February

$$Excel-Macros$$ Match a Word in a cell using Macros

Hi Friends, Need a help to create macro in a "Data" tab where it can recongnize a word either by first/middle/last name if not with full name. for ex - "SHANGHAI ERICSSON SIMTEK " in "Database" tab should help to match the data even by recognizing any one word of this full name from "Data" tab an

Re: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

Thank you Viper ever so much!!! John On Wed, Feb 6, 2013 at 1:20 AM, The Viper wrote: > pfa > > you can modify the range on formula as desired. > > > On Wed, Feb 6, 2013 at 9:34 AM, John A. Smith wrote: > >> Paul, >> >> #1) By using conditional formatting, highlight any row the EXACT target >>

Re: $$Excel-Macros$$ Sumif if criteria 2 match

Dear Champs, All friends, Thanks to all for excellent solution Regards Amar 2013/2/6 NOORAIN ANSARI > 1:23 PM NOORAIN: Hi Amar > pls try > =SUM(IF(($A$2:$A$69=F9)*($B$2:$B$69>6000),$C$2:$C$69,"")) > with ctrl+shift+enter > -- > 13 minutes > 1:37 PM me: thank ver