Adding a divide function to multiple row cells

[Raychin]

Hello!
I have the following problem : in Sheet 2 i have from B6 all the way to B2885 in blocks of 4 rows, the following data inside the cell "=Prediction!$B$6" and so on until B2885 with "=Prediction!$B$725".
The problem is that i have to add in every single row, in Sheet 3, no matter what's inside the cell, a Divide by 4; it's should be looking like this : "=Prediction!$B$6/4" and so on all the way down B2885. So i have to add in every single cell, no matter inside, a "****/4".
I can't figured it out by myself, i don't have the knowledge. Can it be done with VBA macro?
From this

to that

 

[Alex Blakenburg]

You can do it without VBA.
• Enter 4 into a blank cell
• Copy
• Select the cells you want to apply the /4 to
• Paste > PasteSpecial > Divide
• Hit OK
All the formulas should now have "/4" at the end of them.

 

[Legacy 143009]

I will suggest a solution with INDIRECT function but it is not ideal because INDIRECT is a volatile function. Maybe a someone show up with a smarter solution. Sheet 2 B6:

=INDIRECT("Prediction!$B$" & FLOOR(6+((ROW()-6)/4),1))

 

[Alex Blakenburg]

I will suggest a solution with INDIRECT function but it is not ideal because INDIRECT is a non-volatile function.

That should read Volatile.

 

[Raychin]

You can do it without VBA.
• Enter 4 into a blank cell
• Copy
• Select the cells you want to apply the /4 to
• Paste > PasteSpecial > Divide
• Hit OK
All the formulas should now have "/4" at the end of them.

View attachment 77184

Simple and genius!
Thank you both for the quick response to my issue!

 

[Alex Blakenburg]

You're welcome. Glad we could help.