View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
albertmb albertmb is offline
external usenet poster
 
Posts: 81
Default Go to next cell if full

Hi everyone,

I need help if possible:

In cell 'A1' I would like to enter data
I would like to transfer this data to a different cell lets say its cell
'D1' buy 'Cut & Paste'.

Is it possible to have a macro to identify that cell 'D1' contains data so
next entry will be pasted in cell 'D2' and next in cell 'D3' and so on.

Thank you for your kind support.

Albert