help wanted for pulling text data

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,

not quite clear on your requirements but try
data>filter>autofilter

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"ghynes" <ghynes.2cw6bq_1156166705.7066@excelforum-nospam.com> wrote in
message news:ghynes.2cw6bq_1156166705.7066@excelforum-nospam.com...
>
> 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