+ Reply to Thread
Results 1 to 9 of 9

Simple Stock Taking Excel sheet (need help on forumlas etc)

  1. #1
    Registered User
    Join Date
    11-10-2011
    Location
    North West, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Simple Stock Taking Excel sheet (need help on forumlas etc)

    I've set up a rather simple looking (feel free to suggest or change anything)

    http://www.sendspace.com/file/ohks06

    As you can see its very simple! i Just want to add Column E a formula to say if certain number in Column D is met then the Cells in E will say yes or no.

    Then in condtional formatting i want to highligh all rows when YES is met

    p.s. any tinkering to make it visually better are welcome

    thanks all

    Paul

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,773

    Re: Simple Stock Taking Excel sheet (need help on forumlas etc)

    Hi Paul,

    Sounds easy enough, but you haven't explained what number(s) you want in each row to decide if column E shows Yes or No.

    If you can provide that info it will take no time at all to put it together.

    BSB

  3. #3
    Registered User
    Join Date
    11-10-2011
    Location
    North West, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Simple Stock Taking Excel sheet (need help on forumlas etc)

    the number would be various as certain stock runs out quicker than others (if that makes any sense lol)

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,773

    Re: Simple Stock Taking Excel sheet (need help on forumlas etc)

    I'd worked that much out for myself
    Could you tell me what those numbers are? If only for the items in the demonstration data?

    The solution will show you how to deal with more items.

  5. #5
    Registered User
    Join Date
    11-10-2011
    Location
    North West, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Simple Stock Taking Excel sheet (need help on forumlas etc)

    ahh ok sorry haha

    1
    1
    1
    1
    0
    0
    0
    0
    1
    1
    1
    1
    1
    2
    2
    2
    2

  6. #6
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,773

    Re: Simple Stock Taking Excel sheet (need help on forumlas etc)

    I think this is what you mean.

    Two methods.

    1 - Adds an extra column to your original data where you record the re-order level of each item
    2 - Similar to above, but the re-order levels are stored in a list on the second sheet and referenced in the formula with VLOOKUP

    Both similar, both simple, both effective (if indeed this is what you mean!)

    Let me know!

    BSB.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    11-10-2011
    Location
    North West, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Simple Stock Taking Excel sheet (need help on forumlas etc)

    Thank you so much

    i have taken method 1 and hid the Column E row (hope you dont mind)

    i will try and evolve this but cant really think of much more i need to add ?

  8. #8
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,773

    Re: Simple Stock Taking Excel sheet (need help on forumlas etc)

    I don't mind at all... Glad to be of help

  9. #9
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Simple Stock Taking Excel sheet (need help on forumlas etc)

    Here is a very simple inventory workbook that I made up a while back which may give you some ideas. I couldn't find your file to download. All I got was the advertisers' files.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code to pull Stock Balance Sheet Data from a Stock Symbol in a cell
    By akash1229 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-27-2015, 04:37 PM
  2. Stock taking with barcode reader
    By zuzz1991 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2015, 10:11 PM
  3. making an asset Register/ stock taking database
    By Bernad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2010, 07:23 AM
  4. Simple Stock Control Sheet
    By alanled in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-10-2006, 02:35 PM
  5. stock taking help....
    By pete1234 in forum Excel General
    Replies: 0
    Last Post: 03-22-2005, 07:21 PM

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