+ Reply to Thread
Results 1 to 4 of 4

List Items that has been booked out

  1. #1
    Registered User
    Join Date
    02-27-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    18

    List Items that has been booked out

    Good day,
    I have sheets with list of goods and in the last column I have a dropdown box you can choose - book in or booked out. See attached file.
    On another sheet I want a list of all the items that has been changed to booked out.
    Would this be possible?
    Help will be appreciated thank you!

    Regards Sandra
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: List Items that has been booked out

    Hi Sandra!

    There are no "BOOKED OUT" items in these sheets.
    Also wish to know:
    1. how many sheets will be there?
    2. the booking status is in col J for Milling and Turning sheets. But its in col K in Cutter sheet. How will that be? Always in J or K.
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    02-27-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: List Items that has been booked out

    Hi!

    I changed some of them to booked out now.

    There will be 3 oe 4 sheets or I can have it all in one if more than one is not possible.

    Then the list will be in a separate sheet as per new attachment in the yellow block if possible.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-27-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: List Items that has been booked out

    Hi!

    I changed some of them to booked out now.

    There will be 3 oe 4 sheets or I can have it all in one if more than one is not possible.

    Then the list will be in a separate sheet as per new attachment in the yellow block if possible.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1