Auto Assign Sequence Number on Entry

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
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Watch MrExcel Video

Forum statistics

Threads
1,130,110
Messages
5,640,147
Members
417,127
Latest member
shakilk

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top