Mark Benham
New Member
Is there a way of appending a column to a pivot table which allows data to be typed in to it?
I am downloading a Job Costing ledger in to Excel and analysing project performance using pivot table. This makes it easier for non-users of our accounting system to see project performance. The no. of rows in the Pivot Table changes depending on which Project is selected from the Pivot Filter.
I also want to collect actual % complete by each activity within the project from the users. It would be good if I could add a data entry column in to the right of the Pivot Table so the end user can enter % complete for each activity and pass that info back to the downloaded table.
I am downloading a Job Costing ledger in to Excel and analysing project performance using pivot table. This makes it easier for non-users of our accounting system to see project performance. The no. of rows in the Pivot Table changes depending on which Project is selected from the Pivot Filter.
I also want to collect actual % complete by each activity within the project from the users. It would be good if I could add a data entry column in to the right of the Pivot Table so the end user can enter % complete for each activity and pass that info back to the downloaded table.