referencing selected cells

Y

yofnik

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

Marcelo

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



"(e-mail address removed)" escreveu:
 
Y

yofnik

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top