Adding a divide function to multiple row cells

Raychin

New Member
Joined
Apr 7, 2022
Messages
25
Office Version
  1. 2013
Platform
  1. Windows
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
Initial data in the cell.JPG

to that
Added divide to the cell.JPG
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
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.

1666876094931.png
 
Upvote 0
Solution
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:
Excel Formula:
=INDIRECT("Prediction!$B$" & FLOOR(6+((ROW()-6)/4),1))
 
Last edited by a moderator:
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top