copying selected cells to another sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a worksheet that i would like some help with. Here an example of the sheet

A B C

Part #1 $1.00
Part #2 $2.00
Part #3 $3.00

ok, when i put an X in colum C i have it total Colum B, so in other words if i put and X in C1 and C3, i will get a total of $4.00 in another cell. What i would like to do is put the selected items on another sheet one after the other, so if i put and X in C1 and C3 this other sheet will show Part #1 then Part #3 in order with the price in another colum.. I hope this makes sense..

Thanks in advance...

Don
 
Don
Here is one way without using a macro
In the first cell of the second sheet put the following
formula
=MATCH("X",OFFSET(Sheet1!C$2,0,0,20,1),0)
where Sheet1!C$2 is the address of the first cell in the
column for the Xs
and 20 is the number of rows that you want to scan
If there is a match, it will return the item number (not
the part #) otherwise it returns #N/A
In cell under the above formula put the following altered
formulae
=MATCH("X",OFFSET(Sheet1!C$2,A1,0,20,1),0)+A1
where the address A1 points to the first formula. Now copy
it down for how ever many matches you are likely to get.
In the second column of the second sheet put this formula
=IF(ISNA(A1),"",OFFSET(Sheet1!$A$2,A1-1,0))
and copy it down.
Now hide the first column or move it out of sight.

Kevin Beckham

-----Original Message-----
Hi,

I have a worksheet that i would like some help with. Here an example of the sheet

A B C

Part #1 $1.00
Part #2 $2.00
Part #3 $3.00

ok, when i put an X in colum C i have it total Colum B,
Click to expand...
so in other words if i put and X in C1 and C3, i will get
a total of $4.00 in another cell. What i would like to do
is put the selected items on another sheet one after the
other, so if i put and X in C1 and C3 this other sheet
will show Part #1 then Part #3 in order with the price in
another colum.. I hope this makes sense..
 
Kevin,

Thanks! That worked perfectly! thats for taking the time to help me out. I really appreciate your efforts!
 
Back
Top