hello.

Im looking to pull all data from specific cells on one sheet and put
them on a different sheet. I could use the =(cell) function but the
thing is all the specific cells on the first sheet might not have data
in them. and i dont want to have blank cells on the new sheet. is there
anyway i can set it up to pull data from the first cell on the first
sheet and if that doesnt contain any data pull from the next cell and
so on and only have data in the second sheet?

thanks,


--
ghynes
------------------------------------------------------------------------
ghynes's Profile: http://www.excelforum.com/member.php...o&userid=26587
View this thread: http://www.excelforum.com/showthread...hreadid=573747

not quite clear on your requirements but try
datafilterautofilter

--
Don Guillett
SalesAid Software

"ghynes" wrote in
message ...

hello.

Im looking to pull all data from specific cells on one sheet and put
them on a different sheet. I could use the =(cell) function but the
thing is all the specific cells on the first sheet might not have data
in them. and i dont want to have blank cells on the new sheet. is there
anyway i can set it up to pull data from the first cell on the first
sheet and if that doesnt contain any data pull from the next cell and
so on and only have data in the second sheet?

thanks,


--
ghynes
------------------------------------------------------------------------
ghynes's Profile:
http://www.excelforum.com/member.php...o&userid=26587
View this thread: http://www.excelforum.com/showthread...hreadid=573747

sorry! ill try explain it better.

on one worksheet it updates automatically with data in specific cells.
i want to pull all this data and have it displayed on another sheet. i
could use

=A1
=A2
=A3
=A4

and so forth on the new sheet but sometimes there might not be data in
the cells so ill have blank cells on the new sheet.

is there any way i can check the cells for data and if it has data to
send the
data to the new sheet and if not move on to the next cell and check if
that one has data and if so prints in on the new sheet


--
ghynes
------------------------------------------------------------------------
ghynes's Profile: http://www.excelforum.com/member.php...o&userid=26587
View this thread: http://www.excelforum.com/showthread...hreadid=573747