Strugglin Exceller
New Member
- Joined
- Mar 9, 2021
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet that is to calculate door panels. There are 4 panels on the door and they need to be sized so if the height of the door changes, they total values of the panels will never exceed the height of the door.
However, I want to be able to adjust 1, 2 or 3 of any of the panels manually and if I do, the ones I don't define will automatically be equal. Here is a picture of what i'm trying to set up. I have no formulas in any of the cells. but you can see in the picture what I'm trying to do. I would prefer this be done with formulas. However, I'm guessing VBA would be better and that's ok. Your help is very much appreciated.
However, I want to be able to adjust 1, 2 or 3 of any of the panels manually and if I do, the ones I don't define will automatically be equal. Here is a picture of what i'm trying to set up. I have no formulas in any of the cells. but you can see in the picture what I'm trying to do. I would prefer this be done with formulas. However, I'm guessing VBA would be better and that's ok. Your help is very much appreciated.