Forum Discussion
Excel formula combinations
Don't worry, I know that you are dealing with Macros very first time. But once you get the idea about how they work and what they can do for you, you will start learning them. 🙂
Please watch this short demo video (with no audio) to know how this works.
Let me know if doing the same on your end doesn't work for you.
Once VLookup formula returns a price for any product, if you copy the formula cell and paste it back as a Values, that price cell is no longer connected to the first worksheet so any change in price will not affect it. Doing this manually would be a cumbersome task so instead of using VLookup, you may use VBA to get the price of a product from the first worksheet as a value only, that would resolve your issue.
You may consider a Change Event code on second worksheet so that once you select a Product from the drop down in the product column, the corresponding price column is automatically populated with the selected product's price and you will end up having no formula in the price column. Sounds good?
Thank you so much sounds like a problem solver. Can i pick your brain some more i am not so fimiliar with exactly what Change Event code consists of and the implementation thereof.
Regards
VBA solution would be specific to the layout of your data on both the sheets.
If you share your file, I can build a solution for you.
If your file contains private data, save your file to either One Drive or Google Drive and share the link with me in a private message.
OR share a sample file after removing any confidential data which has the layout as same as of your original file, I will build the solution in the sample file and let you know how you can implement the solution in your original file and how to tweak the code if required.
I would be so thankfull no private info just data referring to no one
https://onedrive.live.com/edit.aspx?cid=58b872a7ef66745e&page=view&resid=58B872A7EF66745E!110&parId=58B872A7EF66745E!101&app=Excel.
Regards
Thank You
When I opened the link you provided, all it says is this...
"This item might not exist or is no longer available"
You may upload the file here itself.