BJS
10-27-2015, 05:20 PM
Hi,
I am building an estimating tool.
I have a drop down box that can select multiple values,(jobs). let’s say one of those is “build a shed”
“Build a shed” as 10 associated tasks allocated to it, and other jobs have a varying number of tasks
Once the drop down selection has been made I want a macro that will count the number of tasks against the job and then add those number of rows underneath that drop down then I want to auto populate with the tasks details involved with “Build a shed”, or it can copy the selection from the job and insert direct into the sheet.
Jobs Tasks Duration (Hrs)
Build a Shed A 8
Build a Shed B 7
Build a Shed C 6
Build a Shed D 5
Build a Shed E 4
Build a Shed F 3
Build a Shed G 2
Erect a Fence A 2
Erect a Fence B 6
Erect a Fence C 8
Erect a Fence D 8
Erect a Fence E 2
If there is an easier way, I’m all up for easier.
Any help would be greatly appreciated.
I am building an estimating tool.
I have a drop down box that can select multiple values,(jobs). let’s say one of those is “build a shed”
“Build a shed” as 10 associated tasks allocated to it, and other jobs have a varying number of tasks
Once the drop down selection has been made I want a macro that will count the number of tasks against the job and then add those number of rows underneath that drop down then I want to auto populate with the tasks details involved with “Build a shed”, or it can copy the selection from the job and insert direct into the sheet.
Jobs Tasks Duration (Hrs)
Build a Shed A 8
Build a Shed B 7
Build a Shed C 6
Build a Shed D 5
Build a Shed E 4
Build a Shed F 3
Build a Shed G 2
Erect a Fence A 2
Erect a Fence B 6
Erect a Fence C 8
Erect a Fence D 8
Erect a Fence E 2
If there is an easier way, I’m all up for easier.
Any help would be greatly appreciated.