Copying cells from Sheet1 to Sheet2

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I am new to Excel and was wondering how to perform the simple move.

I have products on sheet2. About 25 of them in the format of

Product Name1, Price, Quantity
Product Name2, Price, Quantity
........
ProductName25, Price, Quantity

The Product Names are filled in and the price is filled in. What I would
like to do is enter a quantity if I want the product. Once I finish
entering in quantities, when i click on Sheet1, I would like the rows that
have a Quantity to be placed on Sheet 1.

How can I do this?

Thanks,

Gary
 
In sheet 1

click in the cell where you want to place the value

then type =
go to sheet 2
then click in the cell you want value from.
 
Hi
try the following array formula in A1 on your sheet1 (entered with
CTRL+SHIFT+ENTER):
=INDEX('sheet2'!A$1:A$30,SMALL(IF('sheet2'!$C$1:$C$30<>"",ROW('sheet2'!
$C$1:$C$30)),ROW()))
and copy this down and to the right

If you want to prevent the error output after no more items with
quantity are found use
=IF(ISERROR(INDEX('sheet2'!A$1:A$30,SMALL(IF('sheet2'!$C$1:$C$30<>"",RO
W('sheet2'!$C$1:$C$30)),ROW()))),"",INDEX('sheet2'!A$1:A$30,SMALL(IF('s
heet2'!$C$1:$C$30<>"",ROW('sheet2'!$C$1:$C$30)),ROW())))
and copy this formula
 
Hi
this would place all prodcuts. If I understood the OP correctly he only
wants the products with a filled quantity
 
Back
Top