Hello everyone,
I would like to upload my workbook but not sure how to do it. I have it saved on my cloud.
First of all I'd like to thank everyone who reads this and attempts to help on any or all of my issues.
I've been working on a workbook to create Estimates for awhile and I need to reach out for any help available because I am completely burned out.
I have tried to lookup how to do the following but can't find anything specific to answer my questions.
My first worksheet "Assemblies" is basically to create up to 3 assemblies to enter on my 2nd worksheet.
My 2nd worksheet "Estimate workup" allows me to build on the assemblies moved to this worksheet by selecting from dropdowns or adding additional information.
My 3rd worksheet " Estimate" is completely automated - or should be. The estimate gets it information from multiple cells.
Problem 1: GOTO Button. I tried to create 3 command buttons so I can select which "mini assembly" I want to goto. I named each assembly range - "Assembly_1", "Assembly_2", and "Assembly_3".
Problem 2: Lookup based on an input. I am trying to automate my 2nd sheet as much as possible. I enter the Category in Column B from a drop down list. I need column C to list the sub-categories related to the specific Category selected in Column B as a drop down item. I have tables on a separate sheet. I also have an item/cost/category sheet.
Problem 2: Save the workbook and Print or email (or both) the "Estimate" worksheet and then clear specific cells/ranges to get ready for the next Estimate.
I want to save the workbook in this format - "estimate #" and "Date"
I would like to upload my workbook but not sure how to do it. I have it saved on my cloud.
First of all I'd like to thank everyone who reads this and attempts to help on any or all of my issues.
I've been working on a workbook to create Estimates for awhile and I need to reach out for any help available because I am completely burned out.
I have tried to lookup how to do the following but can't find anything specific to answer my questions.
My first worksheet "Assemblies" is basically to create up to 3 assemblies to enter on my 2nd worksheet.
My 2nd worksheet "Estimate workup" allows me to build on the assemblies moved to this worksheet by selecting from dropdowns or adding additional information.
My 3rd worksheet " Estimate" is completely automated - or should be. The estimate gets it information from multiple cells.
Problem 1: GOTO Button. I tried to create 3 command buttons so I can select which "mini assembly" I want to goto. I named each assembly range - "Assembly_1", "Assembly_2", and "Assembly_3".
Problem 2: Lookup based on an input. I am trying to automate my 2nd sheet as much as possible. I enter the Category in Column B from a drop down list. I need column C to list the sub-categories related to the specific Category selected in Column B as a drop down item. I have tables on a separate sheet. I also have an item/cost/category sheet.
Problem 2: Save the workbook and Print or email (or both) the "Estimate" worksheet and then clear specific cells/ranges to get ready for the next Estimate.
I want to save the workbook in this format - "estimate #" and "Date"
Last edited: