I'm trying to create a user-friendly timesheet for someone who has never used Excel. How can I create a dynamic range linked to a pivot table with the formula cells locked? I can do dynamic or locked cells but not both. What am I doing wrong? And I'm VBA ignorant, can this be done manually?
Date | Activity | Start Time | End Time | Pause | Total Hours | Details | Amount |
9/3/20 | October newsletter | 9:00 AM | 5:30 PM | 0:30 | 8.00 | $560.00 | |
9/4/20 | October newsletter | 9:00 AM | 6:30 PM | 1:45 | 7.75 | $542.50 | |
9/5/20 | October newsletter | 10:00 AM | 7:30 PM | 1: | 8.50 | $595.00 | |
10/5/20 | Thanksgiving card | 8:00 AM | 9:30 AM | 1.50 | $105.00 |