RE: $$Excel-Macros$$ Help with formula in vba

Hi Ravinder, thanks again for your help however when i use the exact formula it doesnt work, i have been tring to find the issue but couldnt find. this is the exact formula. Range("y2:y" & Range("a1").End(xlDown).Row).Formula = "=" & "IF(K2=" & "AIR" & ",VLOOKUP(X2,'C:\Users\User\Desktop\Repor

Re: $$Excel-Macros$$ Link workbook based on a decision from a lookup

This is basically triggered bases development. Are you using outlook to notify requester of their leave status? What version of Office are you using? On Wed, Nov 27, 2013 at 5:37 PM, Edward Mcallister wrote: > Hi, > > I'm fairly new to Excel as my specialty is JavaScript. I have designed an > A

Re: $$Excel-Macros$$ Re: Sort TCP/IP Address in Excel

great On Mon, Dec 2, 2013 at 6:47 PM, André Roberge wrote: > An easy way to convert IPs to decimal so they can be sorted is to use an > Excel function to do it. See > herefor more > details. > > On Friday, June 24, 2011 5:59:16 AM UT

$$Excel-Macros$$ Re: Please provide the code for data entry as mentioned in excel

dear ashish/ any other guru's, please provide the solution for this On Tuesday, 3 December 2013 19:28:35 UTC+5:30, renuka chari wrote: > > Dear group please provide the solutions for above mentioned. > > thanks > > On Sunday, 1 December 2013 16:48:27 UTC+5:30, renuka chari wrote: >> >> Dear group

RE: $$Excel-Macros$$ Help with formula in vba

Hi Ravinder, thanks a lot, yes this is very helpful. exactly what i needed . :) Thanks and Regards, Gargee Singh From: ravinderexcelgr...@gmail.com To: excel-macros@googlegroups.com CC: quote.ex...@gmail.com Subject: RE: $$Excel-Macros$$ Help with formula in vba Date: Sat, 7 Dec 2013 12:45