$$Excel-Macros$$ Help Required on Dependent Data Validation

Hi, I need help on Dependent Data validation. and please try to solve it without adding any other column. -- Thanks £ Regards Rakesh Kumar +91-9650303464 # -- 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

$$Excel-Macros$$ Re: Help Required on Dependent Data Validation

This solution will work for you !!! To create a dependent drop down list provide some unique values as all persons having the same values .This can be achieved without dependent drop down. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939

Re: $$Excel-Macros$$ Help Required on Dependent Data Validation

You can do so using macro..else you need to use dependent columns for data validation list. + *I did not do this for you. God is here working through me for you.* On Tue, Dec 30, 2014 at 2:48 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: Hi, I need help on Dependent Data validation.

Re: $$Excel-Macros$$ Data Fetch From Particular URL

PLease if possible, share the code. On Sun, Dec 28, 2014 at 6:54 PM, Vaibhav Joshi v...@vabs.in wrote: check this...http://www.wiseowl.co.uk/blog/s393/scraping-websites-vba.htm + *I did not do this for you. God is here working through me for you.* On Sun, Dec 28, 2014 at 12:43 PM,

Re: $$Excel-Macros$$ Data Fetch From Particular URL

Let us know site name what part of data you want to download.. + *I did not do this for you. God is here working through me for you.* On Tue, Dec 30, 2014 at 3:26 PM, Rajeev Ranjan 06raj...@gmail.com wrote: PLease if possible, share the code. On Sun, Dec 28, 2014 at 6:54 PM, Vaibhav

Re: $$Excel-Macros$$ Data Fetch From Particular URL

Data come from company intranet site based the given value(Excel columns Value). eg: website address:- https://?=*excel columns Value* On Tue, Dec 30, 2014 at 3:30 PM, Vaibhav Joshi v...@vabs.in wrote: Let us know site name what part of data you want to download.. + *I

Re: $$Excel-Macros$$ Data Fetch From Particular URL

Its difficult to ans without seeing actual URL, you can try this... Sub Macro1() Dim url As String 'enter your url below in quotes url = https://?=+; Application.ScreenUpdating = False For i = 2 To 100 ' change start date and end date With ActiveSheet.QueryTables.Add(Connection:=

Re: $$Excel-Macros$$ Data Fetch From Particular URL

Its difficult to ans without seeing actual URL, you can try this... Sub Macro1() Dim url As String 'enter your url below in quotes url = https://?=; Application.ScreenUpdating = False For i = 2 To 100 ' change start date and end date With ActiveSheet.QueryTables.Add(Connection:= _

Re: $$Excel-Macros$$ Data Fetch From Particular URL

Joshi I admire your versatile capabilities Sent from my BlackBerry® wireless handheld from Glo Mobile. -Original Message- From: Vaibhav Joshi v...@vabs.in Sender: excel-macros@googlegroups.com Date: Tue, 30 Dec 2014 17:28:28 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com

Re: $$Excel-Macros$$ Data Fetch From Particular URL

Cheers Buddy.. + *I did not do this for you. God is here working through me for you.* On Tue, Dec 30, 2014 at 5:34 PM, meetg...@gmail.com wrote: Joshi I admire your versatile capabilities Sent from my BlackBerry® wireless handheld from Glo Mobile. -- *From: *

Re: $$Excel-Macros$$ Need looping to hide row

Thank you very much...Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 30, 2014 at 12:26 PM, Vaibhav Joshi v...@vabs.in wrote: check this i m not getting any error.. + *I

Re: $$Excel-Macros$$ Data Fetch From Particular URL

Yes, Vaibhav Joshi is the Best. Regards Ashish -- 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

$$Excel-Macros$$ Pull date value from cell

I'm trying to use a For loop to look through a list of dates in a worksheet and flag cells whose dates are greater than 100 days. Set Date_Range = Sheets(Sheet1).Range(A1:A500) YearStartDate = DateSerial(2014, 1, 1) For Each DateVal In Date_Range DateAge = DateVal - YearStartDate

Re: $$Excel-Macros$$ Pull date value from cell

Try reversing the variables, not to result in a negative number: Set Date_Range = Sheets(Sheet1).Range(A1:A500) YearStartDate = DateSerial(2014, 1, 1) For Each DateVal In Date_Range DateAge = YearStartDate - DateVal If DateAge 100 Then MsgBox

Re: $$Excel-Macros$$ Pull date value from cell

Hey try this: Sub date_check() Dim Date_Range As Range Dim DateVal As Range Dim DateAge As Long Set Date_Range = Sheets(Sheet1).Range(A1:A500) YearStartDate = DateSerial(2014, 1, 1) For Each DateVal In Date_Range DateAge = DateVal - YearStartDate If DateAge 100 Then

Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, Please help me on the same issue. Thse sheet is provided by you is not giving correct output. It gives NA# again. Kindly run macro and see the result in Cell C1 and C2. Sheet is attached. Thanks Ashu Kenith -- Forwarded message -- From: Ashu k

$$Excel-Macros$$ Microsoft Excel Certification With Free Training - Hyderabad - Limited Period Offer till 31st Jan'15

*Microsoft Office Specialist Certification* [image: MOS Logo] As a part of promotion for Excelytics Institute, we are offering MOS (Microsoft Office Specialist) Excel Certification with Free Training at discounted price, i.e. Rs. 2000/- (it costs you around Rs.3000/- in the market).