Thread: Copy data from a cell to the next available cell in a range.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
  
Posts: 1,522
Default 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.

Reply With QuoteReply With Quote