Moving data between sheets (tabs?)
 

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