LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Progressive number in different sheets

Hi,

I am trying to have progressive numer in differnt sheets of the same
cell by copying. Can anybody give me a clue? Thanks.

For example, there are three working sheets as below

A1=400 A1=401 A1=402
sheet 1 sheet 2 sheet 3

the A1 of 'sheet 2'! should be 'sheet 1'!A1 +1
and A1 of 'sheet 3'! should be 'sheet 2'!A1 +1

What the formula could be to achieve the above? Thanks.

Lee
 
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
Progressive number with Excel then print a unique Pdf file Mark[_71_] Excel Worksheet Functions 2 July 7th 13 06:56 AM
progressive sum balu Excel Discussion (Misc queries) 3 November 18th 07 06:12 PM
Insert a progressive invoice number George B Excel Worksheet Functions 4 July 1st 07 11:06 PM
Can I have a progressive number in the same cell when printing? Mark Excel Worksheet Functions 0 July 8th 05 12:46 PM
progressive select Mike Excel Worksheet Functions 1 June 8th 05 02:08 AM


All times are GMT +1. The time now is 08:05 AM.

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"