I have a spreadsheet which contains a pivot table (A:D) with several columns of data adjacent to it. The adjacent columns (E:F) contain vlookup formulas based on the job# in column B. The pivot table is subtotaled based on the Foreman.
A B C D E F
Foreman Job Hours Wages JTDLabor JTDHours
Mark 12345 50 $1000 $25000 4000
45678 100 $2500 $15000 3000
Mark total 150 $3500 #N/A #N/A
There are 10 foremen and the number of jobs varies each week.
I would like to be able to autosum columns E and F using bold font and double underline (to match the pivot table format)
This is a whittled down version of the spreadsheet
Hope you can help.
Thank you.
A B C D E F
Foreman Job Hours Wages JTDLabor JTDHours
Mark 12345 50 $1000 $25000 4000
45678 100 $2500 $15000 3000
Mark total 150 $3500 #N/A #N/A
There are 10 foremen and the number of jobs varies each week.
I would like to be able to autosum columns E and F using bold font and double underline (to match the pivot table format)
This is a whittled down version of the spreadsheet
Hope you can help.
Thank you.
