How to step forward every 78 cells.

[dkar75]

Dear All,
Merry Christmas to everybody!

I need your help with this one:

I created a graphic diagram based on some statistics of my job.
Each diagram represent each year.

The function I enter is the following:

=('In Monthly'!$B$318;'In Monthly'!$G$318;'In Monthly'!$L$318;'In Monthly'!$Q$318;'In Monthly'!$V$318;'In Monthly'!$AA$318;'In Monthly'!$AF$318;'In Monthly'!$AK$318;'In Monthly'!$AP$318;'In Monthly'!$AU$318;'In Monthly'!$AZ$318;'In Monthly'!$BE$318)

The above function is for the year 2024.
I want to update the function for the 2025 year.

Each year has from the previous year 78 cells difference.
So the correct type for the 2025 year will be:

=('In Monthly'!$B$396;'In Monthly'!$G$396;'In Monthly'!$L$396;'In Monthly'!$Q$396;'In Monthly'!$V$396;'In Monthly'!$AA$396;'In Monthly'!$AF$396;'In Monthly'!$AK$318;'In Monthly'!$AP$396;'In Monthly'!$AU$396;'In Monthly'!$AZ$396;'In Monthly'!$BE$396)

(318 + 78 = 396)

I don't know what function I must use to add 78 cells in the above function.
So all these years I enter the number of the cells manually.

Is there an easiest way to do this?

Thank you very very much in advanced!

PS) Excuse me for my bad English!

 

[popipipo]

Use Find ($318) and replace ($396)

 

[dkar75]

Use Find ($318) and replace ($396)

Thanks for the answer.
Can you please help me how to do that?

I am not very familiar with the Excel functions.

Thank you!

 

[popipipo]

Use CTRL H
Find what: $318
Replace with: $396

 

[dkar75]

Dear friend Popipipo,

I found Find and Replace but I don't know how to use it, cause I've never use it before.
To see the below formula:

=('In Monthly'!$B$318;'In Monthly'!$G$318;'In Monthly'!$L$318;'In Monthly'!$Q$318;'In Monthly'!$V$318;'In Monthly'!$AA$318;'In Monthly'!$AF$318;'In Monthly'!$AK$318;'In Monthly'!$AP$318;'In Monthly'!$AU$318;'In Monthly'!$AZ$318;'In Monthly'!$BE$318)

I go to diagram right click "Select Data" and the formula appears.
After this step how can I use Find and Replace?

Thank you very much!

 

[Joe4]

Dear friend Popipipo,

I found Find and Replace but I don't know how to use it, cause I've never use it before.
To see the below formula:

=('In Monthly'!$B$318;'In Monthly'!$G$318;'In Monthly'!$L$318;'In Monthly'!$Q$318;'In Monthly'!$V$318;'In Monthly'!$AA$318;'In Monthly'!$AF$318;'In Monthly'!$AK$318;'In Monthly'!$AP$318;'In Monthly'!$AU$318;'In Monthly'!$AZ$318;'In Monthly'!$BE$318)

I go to diagram right click "Select Data" and the formula appears.
After this step how can I use Find and Replace?

Thank you very much!

They gave you the exact steps in the post before your last post. Did you try it?
Just type CTRL+H, and the "Find and Replace" dialogue box will pop up, and you just enter those values, and click "Replace All".

 

[popipipo]

Make a copy of your 2024 formula
Paste in the cell for 2025

Select the cell en use CTRL H

 

[dkar75]

Dear All,
I am very sorry to bother you again with this issue.
The formula is not in a cell but inside the diagram (right click ---> select data)

I also when trying, receive an error message.

 

[dkar75]

Dear Popipipo
First of all Happy New Year

I am really very sorry for bothering you.
I've tried everything but can't make it work.
Something I must understand wrong.

In your last message you mention to copy the formula type of 2024 and paste it in the cell of 2025.
But the formula is not in some kind of cell.
It's inside "Select Data"
It's a Chart!

How can I use find and replace with a formula inside "Select Data"?

Thank you very much!