Mirroring data from multiple sheets into one summary sheet

Closed
Jon.Pasha Posts 1 Registration date Tuesday October 9, 2012 Status Member Last seen October 9, 2012 - Oct 9, 2012 at 07:25 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 9, 2012 at 07:39 PM
Hello,
I have as sheets with data in them, I would like to create a summary sheet in the same workbook such that whenever any of the sheets are updated, the summary is automatically updated with all the contents entered into any of the sheets. I tried consolidation function but it doesn't help my cause as it keeps adding the data and the values in the cell or counting it.
The data is the number of penalty charge notices issued(from Apr 12 to date)/to be issued (in the coming months) during the 12 month period with their issue date, amount etc.

Thanks in advance.
Kind regards,

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 9, 2012 at 07:39 PM
i think u would need to provide more detail. preferably post on a public shared site a sample workbook with how data is and how u would like to see and post back the link to the file back here