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.
|