Hello,
New to the forum and had a quick question.
I have a template that will be used many times. All the sheets are similar but each project will have a different number of sheets. Is there a way to populate the number of the last sheet on each sheet?
My instance, I have a line that says: Sheet No: x of y. where x is the sheet you are on and y is the total number of sheets. Is there a formula that will input y depending on how many sheets there are? Like I said, the total number of sheets each time will be different making this difficult.
Thanks,
Matt
New to the forum and had a quick question.
I have a template that will be used many times. All the sheets are similar but each project will have a different number of sheets. Is there a way to populate the number of the last sheet on each sheet?
My instance, I have a line that says: Sheet No: x of y. where x is the sheet you are on and y is the total number of sheets. Is there a formula that will input y depending on how many sheets there are? Like I said, the total number of sheets each time will be different making this difficult.
Thanks,
Matt