View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rich/rerat Rich/rerat is offline
external usenet poster
 
Posts: 39
Default formula for numbers

Michael,

On First Sheet:
1. Create a Sheet & called it "Log Data", (w/o quotes).
2. Put in the 1st Row your headers. And in A2, #00001.
So it will look like this:

A B C
1 Log Code No Date Log Entry
2 #00001 11/16/08 Went Fishing

In A3 place the following formula:
=if($B3="","",$A2+1)
Drag this formula down Column A.

Custom format Column A like this:
"#"00000

On Second Sheet
1. Create a Sheet & called it "Log Number", (w/o quotes).
2. Put in the 1st Row your headers. Such As:

A B C
1 Log Code No
2

In A2 place the following formula:
='Log Data'!$A2
Drag this formula down Column A.

Custom format Column A like this:
"#"00000

And when you close the Workbook, accept changes to it.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule
<<Previous Text Snipped to Save Bandwidth When Appropriate


"michael" wrote in message
...
I have a log book code #00001 I want this number to add 1 ( example) #00002
every time I start a new entry and store log book code to a different work
sheet