J
Josh Johansen
I have a pivot table that contains 8000 or so entries. What I would like to
be able to do if possible is have a drop down box or even 5 command buttons
that would allow me to highlight that row a specific color based on what date
they selected and if possible add a cell from a column in the pivot table to
an extensive calculation I have already performed. Here is an example:
Job Status No. Job Hours Date
PLANNED 1234 2 blank
PLANNED 1235 6 6/25
PLANNED 1236 4 6/25
PLANNED 1237 3 blank
There are 2 jobs scheduuled on the 25th totaling 10 hours, the user has to
pick a job that can fill 2 more hours, so they would use the drop down box
for job 1234, select the 25th, and it would then be highlighted a specific
color for that day, and hopefully even add those 2 hours to the 10 in a table
outside of the pivot table so as they jobs are more numerous, and they pick
more and more jobs, they have a running total of the hours they have
selected. I know this is very difficult, and maybe it cant even be done, but
I have very little experience with VBA and I am going through everything I
can find to teach myself, so this is sort of a last resort. Thank you for
any help at all.
be able to do if possible is have a drop down box or even 5 command buttons
that would allow me to highlight that row a specific color based on what date
they selected and if possible add a cell from a column in the pivot table to
an extensive calculation I have already performed. Here is an example:
Job Status No. Job Hours Date
PLANNED 1234 2 blank
PLANNED 1235 6 6/25
PLANNED 1236 4 6/25
PLANNED 1237 3 blank
There are 2 jobs scheduuled on the 25th totaling 10 hours, the user has to
pick a job that can fill 2 more hours, so they would use the drop down box
for job 1234, select the 25th, and it would then be highlighted a specific
color for that day, and hopefully even add those 2 hours to the 10 in a table
outside of the pivot table so as they jobs are more numerous, and they pick
more and more jobs, they have a running total of the hours they have
selected. I know this is very difficult, and maybe it cant even be done, but
I have very little experience with VBA and I am going through everything I
can find to teach myself, so this is sort of a last resort. Thank you for
any help at all.