Beyond the already suggested use of events,
Isn't that what formulas do?

The answer would depend on what you mean by Update and what that involves.

--
Regards,
Tom Ogilvy


"mcolson" wrote:

I would like to create a macro that runs continuously while a
spreadsheet is open. I need to be able to enter information into the
spreadsheet, and have the sheet update itself as I enter data.

thanks for your help.