+ Reply to Thread
Results 1 to 4 of 4

Count sheets between two sheets

  1. #1
    Registered User
    Join Date
    11-25-2016
    Location
    Aalborg, Denmark
    MS-Off Ver
    MS Office Pro Plus 2013
    Posts
    7

    Count sheets between two sheets

    Hi,

    I have the following nine sheets in my workbook: "Sheet1,Sheet2,Sheet3,Start,Shoot1,Shoot2,Stop,Sheet8,Sheet9"

    I want a formula that counts how many sheets there are between sheet "Start" and sheet "Stop". Which is two. Naturally if i drag more sheets in between "Start" and "Stop" the calculated number changes.
    I want it to be a formula so that I can divide the number of sheets with a fixed cost I have in the workbook.

    Any ideas?

    Best regards
    Andy

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,874

    Re: Count sheets between two sheets

    Try this:

    =SHEETS(Start:Stop!A1)-2

  3. #3
    Registered User
    Join Date
    11-25-2016
    Location
    Aalborg, Denmark
    MS-Off Ver
    MS Office Pro Plus 2013
    Posts
    7

    Re: Count sheets between two sheets

    Amazing - perfect! Thanks

    Br Andy

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,874

    Re: Count sheets between two sheets

    You're welcome. Happy to help.

    Thanks for the rep!

+ 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] Codes for Prevent users from adding sheets, deleting sheets, hiding/unhiding sheets
    By geniusufo007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-13-2017, 11:57 PM
  2. Compare Sheets and Display the previous sheets column in current sheets
    By maddyrafi1987 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-09-2017, 04:03 AM
  3. [SOLVED] Count single criteria in different sheets (Dinamic sheets)
    By XLalbania in forum Excel General
    Replies: 2
    Last Post: 02-17-2016, 07:06 AM
  4. Create New Sheets, Copy New Sheets & Name New Sheets - 8-O
    By Gtrtim112 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-26-2016, 10:58 PM
  5. Programming code : Sheets.Add After:=Sheets(Sheets.Count)
    By Blok , Robert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2015, 05:00 AM
  6. Create New WB with copy of Sheets 1 & 2 when sheets count reaches 100
    By Corey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2006, 11:55 PM
  7. [SOLVED] sheets count
    By Sheets number position in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2005, 08:05 PM

Tags for this Thread

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