Hi I am using this macro.
It takes long time to run.
So is there a way to fasten it or another alternative solution instead of Vlookup?
![]()
Please Login or Register to view this content.
Hi I am using this macro.
It takes long time to run.
So is there a way to fasten it or another alternative solution instead of Vlookup?
![]()
Please Login or Register to view this content.
Are you carrying out the same lookup many times to get different columns of the same row?
If so, try INDEX/ MATCH to match the relevant row and then just refer to that for the different values you need
For example
Might return the number 32 to denote that the value was found on row 32, then just use this in your ranges, such as![]()
Please Login or Register to view this content.
etc![]()
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
Dear pjwhitfield
Thanks alot for your reply.
I am not expert on macros. The code I posted here was also made by someone else.
I have one question about this code --> Range("h" & a) = Cells(FoundRow,32)
I think this will find the value of Column 32 value in the same worksheet,
how can I make it to find the value in on other Worksheet --> ("Teklif")
Note : Name of the worksheet is "Teklif" which means "Offer"
Dear pjwhitfield
Thanks alot for your reply.
I am not expert on macros. The code I posted here was also made by someone else.
I have one question about this code --> Range("h" & a) = Cells(FoundRow,32)
I think this will find the value of Column 32 value in the same worksheet,
how can I make it to find the value in on other Worksheet --> ("Teklif")
Note : Name of the worksheet is "Teklif" which means "Offer"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks