Re: $$Excel-Macros$$ Re: Scurb two columns using VBA

2013-11-21 Thread Santy
PFA example *Thanks & Regards,* *Santy* On Fri, Nov 22, 2013 at 3:45 AM, Basole wrote: > hi santy, pls. share an example with some data. > > tks. > > > > > > > > Em quinta-feira, 21 de novembro de 2013 15h26min01s UTC-2, Santy escreveu: >> >> Hi All, >> >> >> >> How to scrub how columns usin

$$Excel-Macros$$ Re: Scurb two columns using VBA

2013-11-21 Thread Basole
hi santy, pls. share an example with some data. tks. Em quinta-feira, 21 de novembro de 2013 15h26min01s UTC-2, Santy escreveu: > > Hi All, > > > > How to scrub how columns using VBA for example I have 2 columns both > contain data, I want if first column value matched in second column

$$Excel-Macros$$ Re: HYPERLINKS

2013-11-21 Thread Basole
hi mickey, pls. share an example with some data. tks. Em quinta-feira, 21 de novembro de 2013 20h01min49s UTC-2, Mickey Davis escreveu: > > I have a spreadsheet with links to various cells. The sheet is constantly > changing, so the cell references change. Is there a way I can link from one

$$Excel-Macros$$ HYPERLINKS

2013-11-21 Thread Mickey Davis
I have a spreadsheet with links to various cells. The sheet is constantly changing, so the cell references change. Is there a way I can link from one cell to another, and if the target cell location changes, the link will automatically update? Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Scurb two columns using VBA

2013-11-21 Thread Santy
Hi All, How to scrub how columns using VBA for example I have 2 columns both contain data, I want if first column value matched in second column then first column value should be highlighted via color --- Warm Regards, *Santy* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan

$$Excel-Macros$$ Re: Need code for extracting report from CMS Avaya

2013-11-21 Thread Vinay Sonu
Hey Hi, Seen ur post ... Are you able to connect now... Even i got stucked in the middle please do help me if u are done with this Regards Vinay MV On Friday, June 21, 2013 4:13:44 PM UTC+5:30, Arundatti M wrote: > > Hi Team, > > I need help in extracting report from CMS Avaya CRM application

Re: $$Excel-Macros$$ Vlookup query

2013-11-21 Thread Shrinivas Shevde
Thanks to all problem solved On Thu, Nov 21, 2013 at 3:58 PM, Shrinivas Shevde wrote: > Dear Kartik > thans adn appretiate for the effort. > for the example its ok but for actual it will not work as in actual Column > B and Column D are totally different in column B there is PO no and in > Colum

Re: $$Excel-Macros$$ Re: Vlookup query

2013-11-21 Thread Shrinivas Shevde
Dear shakeel thanks problem solved great Help Regards Shrinivas On Thu, Nov 21, 2013 at 1:51 PM, Shakeel Dhanani wrote: > > You can use Index Match formula instead of VLookup as per Fiel atatched > > On Wednesday, November 20, 2013 4:40:46 PM UTC+5, shrini wrote: >> >> Dear All >> Please find at

Re: $$Excel-Macros$$ Create a macro based on a range of cells in excel and send via Lotus Notes with attachment

2013-11-21 Thread Anoop K Sharma
Hi Kim, can you please share your excel file? On Wed, Nov 20, 2013 at 1:05 AM, Kim McLaughlin wrote: > > > I have a spreadsheet with columns A through AD and have about 1000 rows > on my report. I need to run the report every month and send an email to > anyone that has a greater than or equal

Re: $$Excel-Macros$$ VBA Tips - Learn the name of the Windows user

2013-11-21 Thread Kartik Dale
Hi Folks, For Creating Quick Name Ranges short cut key is Ctrl+Shift+F3+Enter Below is the example table, when you hit Ctrl+Shift+F3+Enter it will create Name ranges for Jan to Aug & Toyota to BMW (Note you should select entire table and press above short cut key) Jan Feb Mar Apr May Jun Jul

Re: $$Excel-Macros$$ Vlookup query

2013-11-21 Thread Shrinivas Shevde
Dear Kartik thans adn appretiate for the effort. for the example its ok but for actual it will not work as in actual Column B and Column D are totally different in column B there is PO no and in Column D there is PR no which are 2 different series at all .for Eg Pr no is 082364 and PO no is 001257

$$Excel-Macros$$ Re: Vlookup query

2013-11-21 Thread Shakeel Dhanani
You can use Index Match formula instead of VLookup as per Fiel atatched On Wednesday, November 20, 2013 4:40:46 PM UTC+5, shrini wrote: > > Dear All > Please find attached query. > Is it possible to write aformula as per my requirement > > -- > Shrini > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT