Can I request your expertise to solve a macro problem.
The attached workbook has got 6 sheets.
Sheet 1 is 'Home'
Sheet 2 is 'A'
Sheet 3 is 'B'
Sheet 4 is 'C'
Sheet 5 is 'D';and
Sheet 6 is 'Consolidated Action Sheet'
Some of the rows in Column F in each sheet has got a text 'Action Item'
I would like to have a macro which helps me to collate all the rows from each sheet with the text 'Action Item' in to the 'Consolidated Action Sheet'
Would be delighted if you can incorporate a step that auto update the Consolidated Action Sheet' when ever data are changed in the relevant sheets
I have tried different options to do this job and you can see my different macros in each sheet.
I am using 2010 excel.
Looking forward for your replies