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