Copying Row Labels when using Subtotal
Posted by PAH on October 24, 2001 6:26 AM
I saw a solution to this on the boards a while back, but can't find it now. Whenever I subtotal a spreadsheet I end up having to manually copy the label from the row above to my subtotal line manually. Is there an easier way? For example if my spreadsheet has column Employee Name and I am subtotaling the hours worked by each Employee, I have to manually copy and past each employee name from the row above to the subtotal line. This becomes really annoying in a large spreadsheet with hundreds of employees.