Hi All,
Hope you are doing great, I have attached a sample file where I am developing a macro and stuck in small piece.
* I have to apply vlookup in Data sheet "B" column, lookup tables are in DUmp sheet column "A-C" , again if there are #n/a we have to do same procedure from column "E-G" and so on..
I did it but same is taking too long time (because main file can have 30000 -50000 rows) as I am applying vlookup in each cell. could you please let me to reduce time of running macro
Hi !
As it exists duplicates in Dump worksheet, it's better you elaborate how to with a complete explanation and samples …
Please see the attached there is no dup. , please also note we can not combine both table
According to the last attachment a starter demonstration :
PHP Code:Sub Demo1()
Dim C%, V, R&
With CreateObject("Scripting.Dictionary")
For C = 1 To Sheet1.UsedRange.Columns.Count Step 4
V = Sheet1.Cells(C).CurrentRegion.Value2
If IsArray(V) Then For R = 2 To UBound(V): .Item(V(R, 1)) = V(R, 3): Next
Next
V = Sheet2.Range("A2", Sheet2.[A1].End(xlDown)).Value2
For R = 1 To UBound(V)
If .Exists(V(R, 1)) Then V(R, 1) = .Item(V(R, 1)) Else V(R, 1) = Empty
Next
Sheet2.[B2].Resize(UBound(V)).Value2 = V
.RemoveAll
End With
End Sub
► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » !
Last edited by Marc L; 08-28-2019 at 08:14 AM.
Thanks Marc, can we do something in my code for improvement that is because I have given a sample file and if I use above code I have to redesign whole macro because I am working on hude data / multiple columns.
As my demonstration is yet designed for multiple columns big data …
@Marc L
Please use code tags ( # button) instead of PHP tags. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks