Results 1 to 3 of 3

Thread: A little help with a formula....?

  1. #1
    Neophyte Ms_Daydream's Avatar
    Join Date
    Jan 2020
    Posts
    2
    Articles
    0
    Excel Version
    1911

    A little help with a formula....?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi everyone! I'm new here. Just wondering if I can get some advice on a little issue I'm having at work.

    Is there a formula that will count down on multiple sheets automatically?


    I am making a ton of Cover Sheets based off of a Table of Contents (TOC), shown on the left. On the bottom are my 7 sheets and the formulas Iíve used on the right. I want the sheets to magically count down the TOC without me having to type in A19,20,21 & B19,20,21 on each sheet.

    Any help would be greatly appreciated!

    Click image for larger version. 

Name:	2020-01-02_18-27-32.jpg 
Views:	18 
Size:	96.1 KB 
ID:	9532



  2. #2
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    52
    Articles
    0
    Excel Version
    1901
    If i understand correctly, H05 auto populate's and then your looking to "magically" auto generate your "Cover sheets" in new tabs?

  3. #3
    Neophyte Ms_Daydream's Avatar
    Join Date
    Jan 2020
    Posts
    2
    Articles
    0
    Excel Version
    1911
    Yes, that is correct.

Posting Permissions

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