Ian

Record a macro while you are doing the updating.

From the Forms Toolbar create a button and assign the macro to the button.


Gord Dibben Excel MVP

On Mon, 7 Nov 2005 16:12:03 -0800, "Ian G"
wrote:

I am looking to provide my dept with an action button within an excel
spreadsheet that when pressed updates all the new data in their relevant
columns.