Forum

Hi Cristian, Without your workbook it's difficult to understand exactly what the issue is, or test what is happening. Please, always attach a work...

Hi Netty, Please don't click the Quote button, it just duplicates the previous post. Use the Add Reply button instead. Thx Phil

You're welcome

The code does enter a VLOOKUP only for visible cells in AA. If you are getting some other result please attach the workbook again so I can see what...

Seems to be, but again, you haven't clearly explained the problem or desired result to I'm guessing. Have you tried it?

Hi, I'm a bit confused. I don't know what sheet you want the code to act upon. All you need is a line like this Sheets("PIR Template").Act...

Hi, When the Validation sub runs you have these 3 lines of code at the top LR = Range("U" & Rows.Count).End(xlUp).Row LR1 = Range("B" ...

Hi Philip, Use a free OneDrive account to store the file then share with us. Phil

Hi Hima, You can use a free OneDrive account to store the file then share the link to it Regards Phil

Philip Treacy said Please supply a workbook with data and clear explanations of what you want and the expected result. Thanks Phil I can't he...

Hi, If data is filtered, for example in a table, VLOOKUP still returns the same data. Filtering has no effect. Maybe if you explain what you ar...

Hi Umesh, I'm not really sure why you are using filters and then copying data between sheets? If I was searching for something I'd write a sub lik...

Hi Umesh, That Google Drive link is asking me to request access for the file. Can't you just attach the file to this thread? Video instructions...