Hi Karen,On 2002-04-16 08:12, karenO wrote:
Can someone help me I have a stock sheet with one column for the prices each item - I want to be able to update prices weekly whilst leaving last weeks costings with the old price. What is the neatest way to do this??
1. Load the existing values to a "history" sheet *before* updating the current prices.
2. Load the current updates to the next row/column available on the current sheet.
Both options would require a date identifier as an additional item, possibly a category header.
HTH,
Jay
Like this thread? Share it with others