Darrell MacDonald
New Member
- Joined
- Mar 25, 2021
- Messages
- 14
- Office Version
- 2010
- Platform
- Windows
Hello
I posted a similar threat recently and had some great help from Fluff and Z51. However, I did a poor job of describing the goal. I'll try again here.
I'm hoping someone can provide me with code that will round up the value in each cell in a specifically chosen column of cells, while maintaining the formula within. For example, could it take a cell with "=F11*locationfactor" as a formula (or any formula, really) who's result is "23,937,012" and make it be "=roundup('PP-6 400'!$M$278,-5)", then bump down to the next cell, do the same with that particular number and continue down to the last number with a value in it?
I hope this is clearer than my last attempt. Thanks in advance. Here's a sample of the columns I'm looking at.
I posted a similar threat recently and had some great help from Fluff and Z51. However, I did a poor job of describing the goal. I'll try again here.
I'm hoping someone can provide me with code that will round up the value in each cell in a specifically chosen column of cells, while maintaining the formula within. For example, could it take a cell with "=F11*locationfactor" as a formula (or any formula, really) who's result is "23,937,012" and make it be "=roundup('PP-6 400'!$M$278,-5)", then bump down to the next cell, do the same with that particular number and continue down to the last number with a value in it?
I hope this is clearer than my last attempt. Thanks in advance. Here's a sample of the columns I'm looking at.