Hi all,
I'm trying to make a worksheet to help me size the parts for cabinet doors. I've made it functional but I was trying to make a bit faster to enter the data and this is where I got a little stumped.
Every door has 2 Rails (horizontal pieces), 2 Stiles (vertical pieces) and one raised or flat panel. Excel calculates the lengths of the rails and stiles as well as the panel size based on the opening size, rail width, stile width, reveal size, and panel expansion room. The above are entered one at a time into their corresponding columns. What I'd like to to is have a "master" rail width and stile width that I'd set and have that be entered automatically when I started to fill in the other info in that row.This I can do but.... I'd also like to be able to adjust the stile width and rail width on a per item basis without changing the "master". Lets say a job I have will use 30 doors with 51mm rails and stiles but a pantry door might have larger rails and stiles. I'd like to change those few doors and keep it on the same cut list. In order to do this I'd have to be able to manually enter the data into the cells that have been pointed to the "master" width. Of course once I do this, the previous formula is gone.
I know I could add another column "add to stile / rails" and sum the two, but I was hoping to learn a better way. Perhaps some VBA? I have no experience when it comes to that but perhaps I could learn something new.
For reference: master rail width is $B$1, rail width is I3. I enter "51" into B1 and then I3 has =IF(A3="",(""),($B$1)). I3 is then used in other cells to provide me with a cut list. Works well until I want to change the rail width.
Any ideas?
Chris
I'm trying to make a worksheet to help me size the parts for cabinet doors. I've made it functional but I was trying to make a bit faster to enter the data and this is where I got a little stumped.
Every door has 2 Rails (horizontal pieces), 2 Stiles (vertical pieces) and one raised or flat panel. Excel calculates the lengths of the rails and stiles as well as the panel size based on the opening size, rail width, stile width, reveal size, and panel expansion room. The above are entered one at a time into their corresponding columns. What I'd like to to is have a "master" rail width and stile width that I'd set and have that be entered automatically when I started to fill in the other info in that row.This I can do but.... I'd also like to be able to adjust the stile width and rail width on a per item basis without changing the "master". Lets say a job I have will use 30 doors with 51mm rails and stiles but a pantry door might have larger rails and stiles. I'd like to change those few doors and keep it on the same cut list. In order to do this I'd have to be able to manually enter the data into the cells that have been pointed to the "master" width. Of course once I do this, the previous formula is gone.
I know I could add another column "add to stile / rails" and sum the two, but I was hoping to learn a better way. Perhaps some VBA? I have no experience when it comes to that but perhaps I could learn something new.
For reference: master rail width is $B$1, rail width is I3. I enter "51" into B1 and then I3 has =IF(A3="",(""),($B$1)). I3 is then used in other cells to provide me with a cut list. Works well until I want to change the rail width.
Any ideas?
Chris