Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 42
Default Auto Numbering a cell on consecutive worksheets

I have a workbook with several worksheets. Each worksheet is an numbered
invoice. As I add worksheets, is it possible to have the invoice number
automatically displayed in consecutive order?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,090
Default Auto Numbering a cell on consecutive worksheets

What are you doing to add worksheets? Post back with a detailed
step-by-step process of what you do to add a worksheet. HTH Otto
"Wally" wrote in message
...
I have a workbook with several worksheets. Each worksheet is an numbered
invoice. As I add worksheets, is it possible to have the invoice number
automatically displayed in consecutive order?



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 42
Default Auto Numbering a cell on consecutive worksheets

I select the tab of the last worksheet and copy.

"Otto Moehrbach" wrote:

What are you doing to add worksheets? Post back with a detailed
step-by-step process of what you do to add a worksheet. HTH Otto
"Wally" wrote in message
...
I have a workbook with several worksheets. Each worksheet is an numbered
invoice. As I add worksheets, is it possible to have the invoice number
automatically displayed in consecutive order?




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
Consecutive Page Numbering with Multiple Worksheets Daria Excel Discussion (Misc queries) 5 October 5th 06 02:08 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Auto page numbering for several worksheets Andy Excel Worksheet Functions 1 March 13th 05 04:41 AM


All times are GMT +1. The time now is 04:57 PM.

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

About Us

"It's about Microsoft Excel"