A little help with a formula....?

Ms_Daydream

New member
Joined
Jan 3, 2020
Messages
2
Reaction score
0
Points
0
Excel Version(s)
1911
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!

2020-01-02_18-27-32.jpg:mod::drama:


 
If i understand correctly, H05 auto populate's and then your looking to "magically" auto generate your "Cover sheets" in new tabs?
 
Back
Top