Recent content by Deepak

Awesome bosco. This SEQUENCE looks interesting, Well, I am not working with excel these days so less known to new functions.

Hi, I think you should to look at (7) Numeric data find out through excel | Chandoo.org Excel Forums - Become Awesome in Excel This is for extracting number and solutions are great. Very interesting solutions by Sajan, Lori, Narayan....

Let's see if this workes, Put in B4 and drag right/down, It's dynamic so you have to update the row 3 correctly. If u have latest xl then that also can be by formula only. =IFERROR(INDEX(Sheet1!$A:$T,MATCH($A4,INDEX(Sheet1!$A:$T,,MATCH(B$3,Sheet1!$4:$4,0)-1),0),MATCH(B$3,Sheet1!$4:$4,0)),"")

Try with adding files as hidden attachment too.

This can be , Hope any one will take care of that of not I will glad to help if get free hand for that.

Hey, I am not much looking bro excel since a long and into web development. Making two sheets will be a good idea. Pls try with ref thread and let me know if still issue, I will try.

Hey! I am not working on VBA as of now, Kindly start a new thread.

New talk of the spreadsheet lovers and vlookup bluffers... Here's XLOOKUP https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376

Hey! VBA easily possible in XL 2007 while opening password is good stuff but still not power proof for who wish to crack it.

Mr faster : Advance Filter

I am afraid that we can login to amazon without the credentials. This doesn't seems possible with VBA itself.

No idea and it will not that easy as well due to both are two different vendors. You must happy with IE when dealing with VBA and web automation.

Hi, Pls check. Option Explicit #If VBA7 Then Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As LongPtr) 'For 64 Bit Systems #Else Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) 'For 32 Bit Systems #End If Sub GSTLogin() Dim url As...

May i reason for the GST website login from VBA, There are plenty of software which offers filling directly from the software via API call and scrapping the said website is illegal as well. There's also captcha, so you can't login in the same way.