Finance | Project Operations, Human Resources, ...

How to get the current page number in electronic reporting?

(0) Share

Report

Posted on by zohaib250

Hi ,

I am new to electronic reporting and working on an excel template where I need to show the current page number in a cell as ( page 1 of 1) as can be seen in the screenshot below .

We can get that in header or footer but as per our requirement we need to display it in one of the cells . Can you please guide me how can i get this value ?

Thanks,

Syed

All responses (5)

Answers (0)

MatthewL2000 5 on at

Like (0)

Report

RE: How to get the current page number in electronic reporting?

I have gotten the same result. Does anyone know how to get current page number in the enabled forumla in order to suppress certain sections? Thank you!
Suggested answer

Huggins Mafigu 480 on at

Like (0)

Report

RE: How to get the current page number in electronic reporting?

You can achieve this by formatting on Excel document itself I guess. For example, if you are working on a word template you can just insert this. Not quite sure about Excel.
Jeb Baker 15 on at

Like (0)

Report

RE: How to get the current page number in electronic reporting?

Hi Syed. I don't think it's possible to do in Excel without VBA code. And you can't import an Excel file with macros into Electronic Reporting.
zohaib250 50 on at

Like (0)

Report

RE: How to get the current page number in electronic reporting?

Hi Ergun,

Thanks for your response , I tried this approach but its not working for me . It simply displays this value in the cell ( Page &P of &N ) .
Suggested answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: How to get the current page number in electronic reporting?

I'm not an expert either, but from the link it seems you can get it with &P.

docs.microsoft.com/.../er-fillable-excel