Norman Rule
Board Regular
- Joined
- May 20, 2009
- Messages
- 59
Good morning.
I am trying to find a way to automatically generate a sequence number when data is entered.
I have to report out of a large spreadsheet which tracks tasks completed. The spreadsheet is used by a half dozen people from a shared location. They can be in and out of the spreadsheet multiple times a day entering their work, but are supposed to have entered all of their work by the end of the day. We've found that some are "forgetting" to do that and end up "accidentally" keeping the spreadsheet open for long periods of time Friday afternoons while they backfill all of their data. This obviously interferes with anyone else trying to use the spreadsheet.
A previous step to try to solve this problem was to use a formula that creates a time stamp of when data is entered. Unfortunately, it appears to use the time native to the entering computer, not the server. People use their own computers remotely, and are all around the country, so that's not reliable in establishing a timeline of events.
If I can generate a sequence number, then I can sort on that to establish who is habitually violating the policy.
I've never worked with VBA, and the client won't allow any macro enabled spreadsheets of documents.
Thanks,
Norman Rule
I am trying to find a way to automatically generate a sequence number when data is entered.
I have to report out of a large spreadsheet which tracks tasks completed. The spreadsheet is used by a half dozen people from a shared location. They can be in and out of the spreadsheet multiple times a day entering their work, but are supposed to have entered all of their work by the end of the day. We've found that some are "forgetting" to do that and end up "accidentally" keeping the spreadsheet open for long periods of time Friday afternoons while they backfill all of their data. This obviously interferes with anyone else trying to use the spreadsheet.
A previous step to try to solve this problem was to use a formula that creates a time stamp of when data is entered. Unfortunately, it appears to use the time native to the entering computer, not the server. People use their own computers remotely, and are all around the country, so that's not reliable in establishing a timeline of events.
If I can generate a sequence number, then I can sort on that to establish who is habitually violating the policy.
I've never worked with VBA, and the client won't allow any macro enabled spreadsheets of documents.
Thanks,
Norman Rule
