Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Updating cells - or not as the case may be

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    London
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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??

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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??
    Hi Karen,

    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

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    1. Load the existing values to a "history" sheet *before* updating the current prices.
    HTH,
    Jay
    Evening Jay,

    just a quickie.... Excel doesn't like it when you try to name a sheet called "history"... it's a reserved name for some reason....

    weird !

    Chris

  4. #4
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Chris,

    Good catch. I did not know that.

    Bye,
    Jay

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •