Hello,
This question may of been asked many times before and I have tried to look for resolutions, but non of the formulaes seem to work.
I'm using Office 365 on a Samsung tablet.
I'm trying to create a file where when I carry out a new project I will duplicate a worksheet, amend the figures, but I want the total figure to show on my summary page.
So for example:
I have a master sheet named 'Summary' and then each worksheet will be named P1, P2, etc and when I add a work sheet I will go up to the next number.
On the summary page I will have P1, P2, P3 listed etc. For the purpose of P1, I want the figure from cell F2 to show on the summary page C4, and then for P3 I want F2 to show on cell C5.
Is there a way to do this, because I happened to come across a post which said 365 has stopped the indirect function for this.
I would like this to auto-populate for new entries of worksheets I add, so eventually P100 will automatically add to the summary page once the worksheet has been created.
Any help will be high appreciated.
Thank you.
This question may of been asked many times before and I have tried to look for resolutions, but non of the formulaes seem to work.
I'm using Office 365 on a Samsung tablet.
I'm trying to create a file where when I carry out a new project I will duplicate a worksheet, amend the figures, but I want the total figure to show on my summary page.
So for example:
I have a master sheet named 'Summary' and then each worksheet will be named P1, P2, etc and when I add a work sheet I will go up to the next number.
On the summary page I will have P1, P2, P3 listed etc. For the purpose of P1, I want the figure from cell F2 to show on the summary page C4, and then for P3 I want F2 to show on cell C5.
Is there a way to do this, because I happened to come across a post which said 365 has stopped the indirect function for this.
I would like this to auto-populate for new entries of worksheets I add, so eventually P100 will automatically add to the summary page once the worksheet has been created.
Any help will be high appreciated.
Thank you.