Hello All,
I currently have a workbook with 3 sheets
Sheet 1: I use the =FILTER() Function to filter the data into only 3 columns for better presentation. Each set of data (the three columns) is presented in Cells A7:C100, D7:G100. I7:K100 etc. The last set is on GK7:GM100.
Sheet 2: Is the logic for how I would like to break out the data
Sheet 3: is all of the Data
I would like to create a MACRO that would take Sheet 1, create a duplicate, copy/paste as values (to remove the formulas) and then format each of these ranges (A7:C100, D7:G100. I7:K100 etc.) into Individual tables for further filtering if required.
Please let me know if this is possible!
Thank you so much
I currently have a workbook with 3 sheets
Sheet 1: I use the =FILTER() Function to filter the data into only 3 columns for better presentation. Each set of data (the three columns) is presented in Cells A7:C100, D7:G100. I7:K100 etc. The last set is on GK7:GM100.
Sheet 2: Is the logic for how I would like to break out the data
Sheet 3: is all of the Data
I would like to create a MACRO that would take Sheet 1, create a duplicate, copy/paste as values (to remove the formulas) and then format each of these ranges (A7:C100, D7:G100. I7:K100 etc.) into Individual tables for further filtering if required.
Please let me know if this is possible!
Thank you so much