Have no idea where to begin with this...
Workbook has multiple sheets; sheet name is date sheet added (e.g., 11-7, 11-10, etc.). Note: New sheets not necessarily added daily.
Columns A-R (could be labeled).
Rows (variable) 3-###.
Cells in each row will contain either:
1) Data in each cell (Col A-R), or
2) Data in Col O-R cells only.
I need a Summary sheet to read only the rows with text in Col A-R from each added sheet, and return only the cell values from columns B,D,E,F,I,J,K,L,M,N of those rows, to begin on Row 9 of the Summary sheet.
And to further complicate matters, I'd be delighted to have said Summary sheet update concurrently each time I add a new sheet (containing unknown number of rows) to the workbook.
Hoping this is easily doable.
Workbook has multiple sheets; sheet name is date sheet added (e.g., 11-7, 11-10, etc.). Note: New sheets not necessarily added daily.
Columns A-R (could be labeled).
Rows (variable) 3-###.
Cells in each row will contain either:
1) Data in each cell (Col A-R), or
2) Data in Col O-R cells only.
I need a Summary sheet to read only the rows with text in Col A-R from each added sheet, and return only the cell values from columns B,D,E,F,I,J,K,L,M,N of those rows, to begin on Row 9 of the Summary sheet.
And to further complicate matters, I'd be delighted to have said Summary sheet update concurrently each time I add a new sheet (containing unknown number of rows) to the workbook.
Hoping this is easily doable.
