Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
referencing selected cells
Hello,
I need some help referencing certain cells from one worksheet in another. Here is an example of what I am trying to accomplish: Worksheet 1: Item # Name Value 1 item1 100 2 item2 0 3 item3 0 4 item4 54 5 item5 0 6 item6 0 7 item7 70 I need to create a separate table in Worksheet2 that as only the NON ZERO values from the table above in Worksheet 1. So the table in Worksheet 2 should look like: Item# Name Value 1 item1 100 4 item4 54 7 item7 70 How do I accomplish this? Thanks for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
referencing selected cells
Hi,
create an auto filter, select the zero different, select the cells, press F5, spcecial, visible ceels only, copy and paste on the new ws hth -- regards from Brazil Thanks in advance for your feedback. Marcelo " escreveu: Hello, I need some help referencing certain cells from one worksheet in another. Here is an example of what I am trying to accomplish: Worksheet 1: Item # Name Value 1 item1 100 2 item2 0 3 item3 0 4 item4 54 5 item5 0 6 item6 0 7 item7 70 I need to create a separate table in Worksheet2 that as only the NON ZERO values from the table above in Worksheet 1. So the table in Worksheet 2 should look like: Item# Name Value 1 item1 100 4 item4 54 7 item7 70 How do I accomplish this? Thanks for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
referencing selected cells
The spreadsheet I am making will be used with many different sets of
data, so the table in Worksheet1 could be different every time. What I am looking for is a formula for accomplishing my goal. Cutting and Pasting is not an option as I want to provide this functionality for the user of the spreadsheet. Can this be done? Marcelo wrote: Hi, create an auto filter, select the zero different, select the cells, press F5, spcecial, visible ceels only, copy and paste on the new ws hth -- regards from Brazil Thanks in advance for your feedback. Marcelo " escreveu: Hello, I need some help referencing certain cells from one worksheet in another. Here is an example of what I am trying to accomplish: Worksheet 1: Item # Name Value 1 item1 100 2 item2 0 3 item3 0 4 item4 54 5 item5 0 6 item6 0 7 item7 70 I need to create a separate table in Worksheet2 that as only the NON ZERO values from the table above in Worksheet 1. So the table in Worksheet 2 should look like: Item# Name Value 1 item1 100 4 item4 54 7 item7 70 How do I accomplish this? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
Excluding selected cells in excel | Excel Discussion (Misc queries) | |||
Macro, Copy Selected Cells Down a Column | Excel Discussion (Misc queries) | |||
one cell's value Highlights selected cells....how? | Excel Discussion (Misc queries) |