[Solved] Display only items with value > 0

[SimonLL]

Hi,

I'm very new to Calc or Excel. I will try to describe what I want to achieve as clearly as possible.

I work as a Lighting technician and as such, I am required to provide an equipment list for every project. Up to now, I have been making these lists as word documents. I would like to simplify the work by having all the equipment listed in a table, and just choose how many of such and such item I need.

Basically, what I thought is the following. On Sheet 1, column A is a quantity and column B is the items descriptions. I would just put the amount of each item I need in column A.

Now the tricky part is that I don't want to output the whole list of items available, but only the ones I choose. So I thought in sheet 2, I should be able to bring only the items that have a value >0 in column A from sheet1. I would like that to be automatic so that whenever I put in numbers in column A of sheet 1, Sheet 2 reflects it by displaying both the quantity and descriptions.

Example:
Sheet 1 : B1:B5 are as follow: 100w, 200w, 300w, 650w, 1Kw
I need 2x300w, 1x650w and 3x1Kw
After I put the numbers in column A, I would like Sheet 2 to reflect the following:
A1=2 B1=300w
A2=1 B2=650w
A3=3 B3=1Kw
Omitting all the items in the list that have a value of 0.

So that if I print Sheet 2 i have a list of only the equipment I need.

Is this making any sense to anyone? If yes, what are the formulas that I need to put in the cells in Sheet 2?

Thanks

Edit: Changed subject, was Functions between sheets  Make your post understandable by others  -- MrProgrammer, forum moderator

[MrProgrammer]

Hi, and welcome to the forum.

By far, the easiest way to display only the needed equipment is to use a single sheet and use Data, Filter, Standard Filter with a criteria of Column A > 0. Or better yet, put the text "Quantity" in A1, begin your inventory in row 2 and use criteria Quantity > 0. But if you really want to use two sheets, see [Tutorial] Sorting and Filtering data with formulas.

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.