Can you set up an automated counter in excel...

[Shower]

IE can you have a cell that says something like "every second you are in this
spreadsheet, we ship this many widgets" and have it increment

 

[Gord Dibben]

Yes, but that's all you would see because any on-time code would run every
second.

You could do nothing else while this code is running.

See Chip Pearson's site for code

http://www.cpearson.com/excel/OnTime.aspx


Gord Dibben MS Excel MVP