Hi All,
I am trying to create a workbook with sheet 1 as a cover sheet. In sheet 2 I will enter data for a project and any queries that have been logged on a certain date. I want the cover sheet to combine the sum of queries for a specific project reference and tell me how many queries I have left to close out.
For example the photo below shows the data I need to enter. I have highlighted the duplicate project numbers.
Data.JPG
The following image is what I want for the coversheet - Showing the project number with the sum off queries and the sum of remaining queries.
cover sheet.JPG
Is there a way of doing this automatically without having to add them all manually and combining the project numbers myself? This is just a sample - the real document has hundreds of columns.
Thanks for anyhelp!
Bookmarks