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

1. ## 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!

2. ## 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. ## 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. ## 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!

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

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