Hello,
I'm trying to create a tool that can generate a set of reports using varying sets of information that is collated in one master pool of information.
The screendump of the spreadsheet contains three workbooks - the Master Set, the Strategy Set, and the Risk Set.
I would like to replicate the Master Set into the workbook for the Strategy Set but for this workbook to contain only rows of data from the Master Set that include the word Strategy in Column B.
I would then like to replicate this process for the Risk Set filtering on the word Risk, rather than Strategy, in Column B.
Any help would be greatly appreciated
Screendump here --> http://i296.photobucket.com/albums/mm193/gemma2425/Excel/Excel1.jpg
I'm trying to create a tool that can generate a set of reports using varying sets of information that is collated in one master pool of information.
The screendump of the spreadsheet contains three workbooks - the Master Set, the Strategy Set, and the Risk Set.
I would like to replicate the Master Set into the workbook for the Strategy Set but for this workbook to contain only rows of data from the Master Set that include the word Strategy in Column B.
I would then like to replicate this process for the Risk Set filtering on the word Risk, rather than Strategy, in Column B.
Any help would be greatly appreciated
Screendump here --> http://i296.photobucket.com/albums/mm193/gemma2425/Excel/Excel1.jpg
