+ Reply to Thread
Results 1 to 4 of 4

Populate data to one sheet from another and a formula to fill cells based on criteria.

  1. #1
    Registered User
    Join Date
    08-02-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    4

    Populate data to one sheet from another and a formula to fill cells based on criteria.

    Hello and thank you all for this awesome support community!

    Here is the jist.

    I am making a grocery list that has some minimal functionality.

    I have a stock number I want to always purchase up to. I have a current on hand quantity that I take an inventory on. The difference of the Wanted Stock vs the current on hand is on a new Sheet called Shopping List.

    On the shopping list page it simply copies the information from the main sheet and puts the result of the difference of the Wanted stock vs On hand quantity next to the item name. It will look like this:

    Main List

    Name: Stock On hand

    Carrot 3 1

    Celery 2 1.5


    Shopping List Sheet


    Name: Qty Needed

    Carrot 2

    Celery .5

    So here is what I am requesting some assistance with. I am using conditional formatting to FILL a cell(Blackout) that is <= 50% of the value of the Stock number on the main page.

    The purpose is to have the shopping List created and the only items that I will see not blacked out are the items that I need to purchase which I want to be when I fall below a 50% threshold on that particular item.

    Right now I have created a conditional format for each individual item I want blacked out. Ex.


    Formula: =$B$29<.5 Format Black Fill Applies to =$A$29:$B29

    This is the old formula I had before deciding on this new way to black fill by looking at the 50% value threshold.

    I really appreciate the time you took to look at this and to anyone who has an idea or word of encouragement on this thank you also!
    Attached Files Attached Files
    Last edited by superCWdad; 08-02-2020 at 03:41 PM. Reason: Added my Workbook for viewing

  2. #2
    Registered User
    Join Date
    08-02-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    4

    Re: Looking for a Formula Assist. Fill Cell based on another cells result + 1 step

    Ohh I have an idea that would be cool.

    Could I have something run to auto populate the shopping list simply based off of the stock qty vs on hand qty main sheet. Something that will take all appropriate items and populate the list automatically?

    The shopping list would pull the item name the needed qty. It would only populate the items that are under 50% less than the Stock amount.

    Then I would not need t black anything out because only items I need to buy would be on the Shopping List.

    I LIKE IT! Can it be done?

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    5,738

    Re: Populate data to one sheet from another and a formula to fill cells based on criteria.

    There are lots of this kind of issues those you can search in the forum.
    In A3:
    Please Login or Register  to view this content.
    B3:
    Please Login or Register  to view this content.
    Similar to d3:
    Please Login or Register  to view this content.
    e3:
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-02-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    4

    Re: Populate data to one sheet from another and a formula to fill cells based on criteria.

    Wow thank you for the reply bebo021999!

    Looks like my Excel skills are at the novice level as I am not quite sure what all those pastes are exactly but I will play around with them and figure it out. Thank you again for the assist!

    I will learn some more skills to get this sheet squared away!

+ 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. [SOLVED] Linking 1 tab to another based on a cell result, picks a column based on result formula
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-23-2018, 11:08 AM
  2. I want to fill multiple cells based on the result in one cell
    By crashwg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-04-2014, 01:47 PM
  3. [SOLVED] For step loop, need step size to change based on reference cell in row
    By Telperion in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2013, 03:41 PM
  4. Formula to fill cells based on the date in another cell
    By PowerPlayer23 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2012, 02:26 PM
  5. Directly print cell formula values step by step
    By SMM in forum Excel General
    Replies: 0
    Last Post: 07-08-2010, 08:27 PM
  6. VBA to SHADE cells based on: step-size & starting cell
    By zusammen in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-14-2009, 10:09 AM
  7. [SOLVED] I can see formula result when I step into it but not in the cell
    By Benoit in forum Excel General
    Replies: 1
    Last Post: 03-16-2006, 08:25 AM

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