Hi,
I have created a meeting minutes/actions in excel. Each new meeting will be created into a new sheet with the template.
Now I wish to extract all the actions from the minutes into a new 'action log' sheet so that I can track the actions and create a log for it.
The following may simplify what I am trying to do:
Meeting1_01042019 (worksheet name)
Meeting2_03042019 (worksheet name)
Action_Log (worksheet name)
Within the worksheets meeting minutes, I will uniquely identify the actions (MA_001, MA_002, MA_003).
So the query I want is to extract the rows which have anything "MA" in it and paste into the sheet called Action_Log.
I have created a meeting minutes/actions in excel. Each new meeting will be created into a new sheet with the template.
Now I wish to extract all the actions from the minutes into a new 'action log' sheet so that I can track the actions and create a log for it.
The following may simplify what I am trying to do:
Meeting1_01042019 (worksheet name)
Meeting2_03042019 (worksheet name)
Action_Log (worksheet name)
Within the worksheets meeting minutes, I will uniquely identify the actions (MA_001, MA_002, MA_003).
So the query I want is to extract the rows which have anything "MA" in it and paste into the sheet called Action_Log.