F
Fredrik Wenngren
Hi all, sorry for the potential newbie-question but I really didn´t know what
to search for...
I have an Excel 2003 file with 3 sheets (tabs) in it. All 3 sheets look the
same but I would like the third sheet to only show the products bought on
sheet 1 & 2.
The first two sheets are the product-lists - which are pre-filled with
product information and prices. One product for each row and the "F"-Column
is where i will enter the amount of each product which has been purchased -
default value is blank.
However on the 3´d sheet i would like to collect all the products from sheet
1 & 2 that has a value in the F-column. (eg. 1, 2, 3 or 4...)
I do not want the products with a "blank"-value in the F-column to be listed
under sheet 3.
Which commands should i get into to accomplish this?
To clarify: I would like the Products chosen from Sheet 1 AND 2 to be filled
in automatically if they are given a value of 1 or more in the "F"-column.
Very thankful for all help and suggestions.
/ Fredrik W
to search for...
I have an Excel 2003 file with 3 sheets (tabs) in it. All 3 sheets look the
same but I would like the third sheet to only show the products bought on
sheet 1 & 2.
The first two sheets are the product-lists - which are pre-filled with
product information and prices. One product for each row and the "F"-Column
is where i will enter the amount of each product which has been purchased -
default value is blank.
However on the 3´d sheet i would like to collect all the products from sheet
1 & 2 that has a value in the F-column. (eg. 1, 2, 3 or 4...)
I do not want the products with a "blank"-value in the F-column to be listed
under sheet 3.
Which commands should i get into to accomplish this?
To clarify: I would like the Products chosen from Sheet 1 AND 2 to be filled
in automatically if they are given a value of 1 or more in the "F"-column.
Very thankful for all help and suggestions.
/ Fredrik W