My boss was asking me to make a macro that could do something like this.

The workbook has 7 sheet's, each sheet is a report, sheet 1 is an x-ray
report, sheet 2 is an dyepen report etc etc. Every report has its own report
number (from report 1 to .....). My boss's problem is that different user's
use a report number that may have been used before. He want's me to make a
macro that controll the input on every report, thats not a problem.

My problem is that, in cell D5, the report number should +1 for every time a
report is made. Also, the first time its opened it should be 1 the second
time its opened it should be 2, and this only for the active sheet. Is this
possible?

Michael,

I'm afread if it is a multuser report and all users should use distinct
report numbers for each sheet, it would be best to split up the
workbook per report/sheet. Also your file should be on the network.

I can help you with a Macro that will:

Update a number on opening the workbook from the newtork, and will also
save that back to the network, so other people opening it will user
other numbers.
After that the code will prompt the user to save the file locally for
further processing, so other people can access the network file again.

This ensures unique numbers across all users using the workbook on the
network

DM Unseen

Better to write the number to a network file wouldn't it and then increment
that number at the appropriate time.

--
HTH

Bob Phillips

"DM Unseen" wrote in message
oups.com...
Michael,

I'm afread if it is a multuser report and all users should use distinct
report numbers for each sheet, it would be best to split up the
workbook per report/sheet. Also your file should be on the network.

I can help you with a Macro that will:

Update a number on opening the workbook from the newtork, and will also
save that back to the network, so other people opening it will user
other numbers.
After that the code will prompt the user to save the file locally for
further processing, so other people can access the network file again.

This ensures unique numbers across all users using the workbook on the
network

DM Unseen

Sub Auto_Open()
Range("D5").Value = Range("D5").Value + 1
End Sub


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200507/1

See J.E. McGimpsey's site for some sample code:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Which may help.
--
Regards,
Tom Ogilvy

"Michael" wrote in message
...
My boss was asking me to make a macro that could do something like this.

The workbook has 7 sheet's, each sheet is a report, sheet 1 is an x-ray
report, sheet 2 is an dyepen report etc etc. Every report has its own
report
number (from report 1 to .....). My boss's problem is that different
user's
use a report number that may have been used before. He want's me to make a
macro that controll the input on every report, thats not a problem.

My problem is that, in cell D5, the report number should +1 for every time
a
report is made. Also, the first time its opened it should be 1 the second
time its opened it should be 2, and this only for the active sheet. Is
this
possible?