Copy data from a cell to the next available cell in a range.
 

layout and examples


On Feb 2, 10:20*pm, Linck Schlich wrote:
OK,
So I have several ranges of cells which I will place account numbers.
I would like to have a collection, in a separate column of ALL the
account numbers.

So, I would like to, when I place an account number in any of the
cells of the aforementioned ranges, it would be copied to the next
available column in a separate range.

Thank you in advance for any help.

Copy data from a cell to the next available cell in a range.
 

Sure!

So, given ranges A1:B10 AND C1:D10, none of which are merged, and are
just simple cells that could hold data.

I want that if ANY of those cells in EITHER of those ranges have data,
then that cell would be copied automatically to range E1:E40 into the
NEXT available cell in that range.
So, column E would just be a list of any cells in the other two ranges
that had any data.

Thank you for your time.

On Feb 3, 8:00*am, Don Guillett wrote:
layout and examples

On Feb 2, 10:20*pm, Linck Schlich wrote:







OK,
So I have several ranges of cells which I will place account numbers.
I would like to have a collection, in a separate column of ALL the
account numbers.

So, I would like to, when I place an account number in any of the
cells of the aforementioned ranges, it would be copied to the next
available column in a separate range.

Thank you in advance for any help.

Copy data from a cell to the next available cell in a range.
 

I should also say that I only want to copy the data from the cell...
not the cell's formatting, etc..

On Feb 3, 3:46*pm, Linck Schlich wrote:
Sure!

So, given ranges A1:B10 AND C1:D10, none of which are merged, and are
just simple cells that could hold data.

I want that if ANY of those cells in EITHER of those ranges have data,
then that cell would be copied automatically to range E1:E40 into the
NEXT available cell in that range.
So, column E would just be a list of any cells in the other two ranges
that had any data.

Thank you for your time.

On Feb 3, 8:00*am, Don Guillett wrote:







layout and examples

On Feb 2, 10:20*pm, Linck Schlich wrote:

OK,
So I have several ranges of cells which I will place account numbers.
I would like to have a collection, in a separate column of ALL the
account numbers.

So, I would like to, when I place an account number in any of the
cells of the aforementioned ranges, it would be copied to the next
available column in a separate range.

Thank you in advance for any help.