Move row of information to bottom of worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if there is a way to move a row of information to the bottom of a worksheet after that row has been completed. For example if column N has a entry in it can it automatically be moved to the next empty row of information.
 
Hi

Do you want the curser to go to the next row in the A column after you change N?
Or do you want to copy the row on the bottem of a database list?

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Sboerger said:
I was wondering if there is a way to move a row of information to the bottom of a worksheet after that row has been completed.
Click to expand...
For example if column N has a entry in it can it automatically be moved to the next empty row of information.
 
I guess I phrase this wrong. What I want to do is move the information from the present line to bottom of database worksheet after column "N" has been filled with data.
----- Ron de Bruin wrote: ----

Start looking at the examples on this pag
http://www.rondebruin.nl/copy1.ht

Post back if you need more hel
 
Hi

You can use the change event to run the macro
see Chip Pearson's site about Events

http://www.cpearson.com/excel/events.htm

And use in the change event

If Target.column = 14 then
'macro name
End if

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Sboerger said:
I guess I phrase this wrong. What I want to do is move the information from the present line to bottom of database
Click to expand...
worksheet after column "N" has been filled with data.
 
Back
Top