Summary Sheet Pulling from Multiple Sheets Dependent on a Certain Criteria

[gped123]

Hi,

I'm building an action tracker at work to monitor actions arising from the various meetings.

Within the spreadsheet, there are numerous worksheets, all with the same sub headings.

Within the sub headings there are 'Reference, 'Description & Action', 'Owners', 'Action Owner', 'Due Date', 'Complete' and 'Comments'.

I would like to be able to extract all actions related to a particular individual (i.e. Action Owner) and then summarise those actions in a summary worksheet which is pre-formatted.

Therefore, I'm guessing that I will need either a macro or VBA code to help me to do the following:

• Allow me to search by name and then pull all information related to that individual into a separate summary worksheet with all actions.
• Consolidate this data so that if there are duplicates of the same description, it is shown only once with the sum of all values relating to that description

Any advice would be appreciated.

Thanks!

 

[gped123]

Hi Guys, Would anyone be able to to help please? Would really appreciate some advice. Thank you!