Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying selected cells to another sheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying selected cells to another sheet
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, 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying selected cells to another sheet
Have a look at the SUMIF() worksheet function in Excel Help.
Regards BrianB ------------------------------------------------ Don wrote in 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, 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying selected cells to another sheet
Kevin,
Thanks! That worked perfectly! thats for taking the time to help me out. I really appreciate your efforts! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cells from one sheet to another | Excel Worksheet Functions | |||
copying only selected data from Sheet 1 to Sheet 2 | Excel Worksheet Functions | |||
how to name the selected cells in a sheet? | Excel Worksheet Functions | |||
how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet. | Excel Worksheet Functions | |||
Copying selected rows to another sheet | Excel Worksheet Functions |