Automatically increment Sequence Number on Excel Sheet
Posted on 2007-07-31
Here is what I think is an interesting one. I "Weekly Update" sheet at work here. My boss would like the sheet to be numbered, i.e. Weekly update number 1, 2, etc. The problem is the weekly update gets run a few times a week! So I don't want it to increment every time I run it. Is there a way to set the increment so that it updates automatically once a week, say on Monday's at 9am? Sorry, I have a habit of not being clear, when I say we "run" the sheet I mean it is built basically from scratch by a macro each time we "run" it, so I'm looking for something to incorporate into the macro.