Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 15th 08, 04:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 791
Default formula for numbers

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

  #2   Report Post  
Old November 15th 08, 05:28 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default formula for numbers


You need to give us a little more to go on than that, however i think
what you want to achieve will need a little VBA.


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=29994

  #3   Report Post  
Old November 15th 08, 05:33 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,101
Default formula for numbers

Not really sure what your asking ?? Could you give a little more detail.

"michael" wrote:

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

  #4   Report Post  
Old November 16th 08, 10:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula - Add column of numbers but ignore negative numbers view for Distribution List members Excel Worksheet Functions 1 April 7th 06 03:13 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? C-Man23 Excel Worksheet Functions 3 January 19th 06 10:52 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? C-Man23 Excel Worksheet Functions 1 January 9th 06 02:23 PM
IF formula and whole numbers jdmagoo New Users to Excel 1 October 5th 05 04:39 PM
I PUT A FORMULA IN A CELL BUT I DON'T GET NUMBERS BUT THE FORMULA lady one Excel Worksheet Functions 3 September 24th 05 01:46 PM


All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017