Hello everyone!
I make a report (which does not depend on me, and I cannot have it done any other way) that is made up of two Excel files.
In the second file I need the number of sheets to consider those that are already in the first. That is, if the first file has 2 sheets, the second file should start counting as page 3 of total pages+2
In configuring footer I can do &[page]+2 of &[pages]+2 but what for [page] works in [pages] does not and where it should tell me 3 of 10 it tells me 3 of 82
Can you help me?
Any help or advice will be gladly received.
I make a report (which does not depend on me, and I cannot have it done any other way) that is made up of two Excel files.
In the second file I need the number of sheets to consider those that are already in the first. That is, if the first file has 2 sheets, the second file should start counting as page 3 of total pages+2
In configuring footer I can do &[page]+2 of &[pages]+2 but what for [page] works in [pages] does not and where it should tell me 3 of 10 it tells me 3 of 82
Can you help me?
Any help or advice will be gladly received.