Is there a way for excel to log a number from one sheet into another.
I am creating a pricing log and I currently have about 10 sheets calculating off of my main sheet Column B.
Every month new pricing will be entered into the main sheet Column B for all of my ingredients.
Is there a way in a separate sheet to log automatically the numbers as they are changed?
For example in January I enter 10.00 for an item. Can that be logged in B1 on a separate sheet.
When I change the pricing in February to 15.00 the 10.00 stays unchanged in B1 and in column C1 the new pricing $15.00 is logged and so on...
I have attached a spreadsheet.
Any help would be much appreciated as always!!
Bookmarks