Hello everybody,
I am trying to consolidate rows from tables on multiple worksheets into one table in new master worksheet. Tables have the same amount of columns from A to J but not same amount of rows. Condition for rows I want to consolidate to new table is the blank cell in column F. In column F I have responses for specific task and blank space means that the response has not been made yet. I need to create new table where I can see the tasks without response. Or it would be better to write some phrase for no response instead of blank cell to create condition in macro easier? Also another condition is to pick rows only from visible worksheets.
Is anybody her who knows how to do this macro?
Please advise.
Thank you very much for your time.
I am trying to consolidate rows from tables on multiple worksheets into one table in new master worksheet. Tables have the same amount of columns from A to J but not same amount of rows. Condition for rows I want to consolidate to new table is the blank cell in column F. In column F I have responses for specific task and blank space means that the response has not been made yet. I need to create new table where I can see the tasks without response. Or it would be better to write some phrase for no response instead of blank cell to create condition in macro easier? Also another condition is to pick rows only from visible worksheets.
Is anybody her who knows how to do this macro?
Please advise.
Thank you very much for your time.
