I don't even know if this can be done, but if anyone can solve it someone on here will!
I have a workbook with 9 worksheets (Mod 1 to Mod 9). Each sheet has a column that will be completed with yes, no or na (column D) but the number of rows on each sheet varies. If "no" is entered, comments will be put in column E. From these multiple sheets I need to pull all the comments into a separate summary report, along with the related data in columns B and C (question number and question). I can have interim sheets to help with this if necessary, but the user will not be expected to do anything other than enter yes, no, na and maybe press a button if a macro is needed!
Any suggestions would be very welcome - with such variable data ranges I can't see a solution. My only idea would be to pull all rows into one sheet and then use a macro to filter automatically - but how do I do that?
I have a workbook with 9 worksheets (Mod 1 to Mod 9). Each sheet has a column that will be completed with yes, no or na (column D) but the number of rows on each sheet varies. If "no" is entered, comments will be put in column E. From these multiple sheets I need to pull all the comments into a separate summary report, along with the related data in columns B and C (question number and question). I can have interim sheets to help with this if necessary, but the user will not be expected to do anything other than enter yes, no, na and maybe press a button if a macro is needed!
Any suggestions would be very welcome - with such variable data ranges I can't see a solution. My only idea would be to pull all rows into one sheet and then use a macro to filter automatically - but how do I do that?
