Need help with copying data from cells

I currently need to get the data from an entire column of cells, and add them to column. The thing is, the data in the column is not a straight line, there are blank cells in between data entrys in the column.

Basically, i need to copy the data values only from the cells that contain data, where it is put in one neat straight line in another column.


Hopefully this makes sense...

Select the column, use Edit / Go To... Special, constants (if your data is actually constant
values) then OK. Ctrl-C, then select a cell at the top of your other column and press Ctrl-V.

HTH,
Bernie
MS Excel MVP


"paulket" <paulket.1rdzyb_1120046712.2334@excelforum-nospam.com> wrote in message
news:paulket.1rdzyb_1120046712.2334@excelforum-nospam.com...
>
> I currently need to get the data from an entire column of cells, and add
> them to column. The thing is, the data in the column is not a straight
> line, there are blank cells in between data entrys in the column.
>
> Basically, i need to copy the data values only from the cells that
> contain data, where it is put in one neat straight line in another
> column.
>
>
> Hopefully this makes sense...
>
>
>
>
> --
> paulket
> ------------------------------------------------------------------------
> paulket's Profile: http://www.excelforum.com/member.php...o&userid=24742
> View this thread: http://www.excelforum.com/showthread...hreadid=383093
>

ahh. sorry, i forgot to mention that this needs to automatic.

I could use a filter to filter all the data by NonBlank.. however, if there is data added to the filtered column, it does to add them to the filter range. In other words, the data is in the column, just not getting filtered untill you unfilter then filter again.

Everything MUST be done automatically... which makes it hard

paulket,

Would a macro work for you? Tell us what sheet/column/cells for the source, and what
sheet/column/cell for the copied values. And do you want to over-write old values?

HTH,
Bernie
MS Excel MVP


"paulket" <paulket.1rhbea_1120201504.3309@excelforum-nospam.com> wrote in message
news:paulket.1rhbea_1120201504.3309@excelforum-nospam.com...
>
> ahh. sorry, i forgot to mention that this needs to automatic.
>
> I could use a filter to filter all the data by NonBlank.. however, if
> there is data added to the filtered column, it does to add them to the
> filter range. In other words, the data is in the column, just not
> getting filtered untill you unfilter then filter again.
>
> Everything MUST be done automatically... which makes it hard
>
>
> --
> paulket
> ------------------------------------------------------------------------
> paulket's Profile: http://www.excelforum.com/member.php...o&userid=24742
> View this thread: http://www.excelforum.com/showthread...hreadid=383093
>