+ Reply to Thread
Results 1 to 2 of 2

Need a sequence of numbers in the same cell on multiple sheets

  1. #1
    Registered User
    Join Date
    12-10-2011
    Location
    Saskatchewan
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need a sequence of numbers in the same cell on multiple sheets

    Hello,

    I'm trying to label sheets using cell G4.
    My first sheet is 162, then 164, 166, 168, etc., up to 450.
    If I Shift-click all my sheets and select cell G4, I should be able to use a formula to calculate a sequence of numbers going up by 2 starting at 162.
    How would I write that formula?

    Please redirect me if you can

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Need a sequence of numbers in the same cell on multiple sheets

    You are pushing your luck asking for a formula to do that.

    Why not use a simple Macro instead?

    Please Login or Register  to view this content.

    This can be even simpler with hind sight.


    Please Login or Register  to view this content.
    Last edited by mehmetcik; 01-20-2014 at 03:50 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to create new sheets with numbers in sequence
    By canyflyer in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-21-2013, 07:11 PM
  2. [SOLVED] align or combine multiple columns from multiple sheets into one sheet in sequence
    By calif in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2013, 11:49 AM
  3. Multiple excel sheets into one with different cell numbers
    By scubadivingfool in forum Excel General
    Replies: 3
    Last Post: 05-10-2012, 10:03 AM
  4. Replies: 8
    Last Post: 06-24-2009, 07:27 AM
  5. Replies: 6
    Last Post: 08-02-2006, 11:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1