Results 1 to 1 of 1
  1. #1
    New Lounger
    Join Date
    Feb 2009
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I worked on this spreadsheet about 5 years ago and sent it to the inventory department. Something has changed over the years that is not allowing a smooth conversion to Excel 2007. This is the process:

    The inventory clerk enters the actual amount in column F(Actual)
    When column F(Actual) drops below column G(RO Point), the amount in column H(RO#) is placed in column C(Needed). An (*) is placed in column D(Sort)
    The order is placed and the amount ordered is then entered into column B(Ordered) and column D changes from (*) to "On Order"
    The number of received items is entered into column A(Rec'd) when they arrive.
    This resets the columns and adds the amount received to the number in column F(Actual)

    Can someone please debug this file to work with 2007?

    Thanks for the help.
    Attached Files Attached Files

Posting Permissions

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