Vlookup on an other sheet

[Quisemar]

Hello Forum,

I am trying to apply a Vlookup function into two different worksheets of a unique workbook.
I also need my code to be dynamic as number of rows is subject to change drastically.

Despite many tries I am unable to run my macro without any compile error..
My last try was by adapting a previous code extracted from a different macro, but as it is in R1C1 style I am not sure about what I am doing.

Would you have any idea ?


Sub Billing_v2()

Please Login or Register  to view this content.

Thanks!!

[Winon]

Hello Quisemar,

Maybe we should consider the Match Function instead of VLookUp?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[stnkynts]

You didn't really explain what you are trying to accomplish in your sheet so I made a few assumptions. Any incorrect assumptions will need be corrected in the code by yourself.

Please Login or Register  to view this content.

[Quisemar]

Stnkynts, after adapting it, it works fine !
Many thanks !!