Forum Discussion
I want to update prices on a list by entering name and current price values on a seperate sheet
I am building a restaurant inventory workbook and it's been years since I created complex workbooks. I have created an item master that has all inventory items and their most current price by siz...
This discussion has received nearly 50 views but no responses yet. I think everything you mentioned can be done with formulas. The reason there haven't been replies yet is it's difficult picturing what your workbook arrangement looks like. If you have an anonymized sample workbook you can upload or share via OneDrive/Dropbox, etc. - it will help you get a solution (or two or three) very quickly.