Need help with copying data from cells

  • Thread starter Thread starter paulket
  • Start date Start date
P

paulket

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

:confused:
 
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
 
ahh. sorry, i forgot to mention that this needs to automatic.

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

Everything MUST be done automatically... which makes it har
 
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
 
hmm.. macro. diddnt think of that.

I suppose I could use a macro to filter it then assign it to a form
button.
Although it wont be automatic, it will however be very simple to use.

The sheet is comparing products of a product spreadsheet to an updates
spreadsheet and getting the new products that are not listed.
 
Back
Top