I am trying to move data in "Sheet 1" into newly created tabs.
These tabs are created and named based on a list of values. These can change once opening the workbook.
For example, we might create tabs A, B, C, D, E and the next day these tabs could be F, G, H, I, J.
Now, I want to move data in "Sheet 1" if the value in column "O" is the same as the name of the newly created tab.
So for example, I want all the rows copied from "Sheet 1" that contain value "B" in column "O" to be moved to the tab "B" and those that contain "C" to be moved to tab "C".
The names of these tabs are in a dynamic list. Currently, the workbook creates these tabs from this list that could be only 4 entries, or could be 25 entries in the list.
Is there a loop that we can run to move data to the appropriate tab if the value matches the name of the tab?
I do not have any current code, as anything I have tried using AutoFilter has not worked.
Thanks
These tabs are created and named based on a list of values. These can change once opening the workbook.
For example, we might create tabs A, B, C, D, E and the next day these tabs could be F, G, H, I, J.
Now, I want to move data in "Sheet 1" if the value in column "O" is the same as the name of the newly created tab.
So for example, I want all the rows copied from "Sheet 1" that contain value "B" in column "O" to be moved to the tab "B" and those that contain "C" to be moved to tab "C".
The names of these tabs are in a dynamic list. Currently, the workbook creates these tabs from this list that could be only 4 entries, or could be 25 entries in the list.
Is there a loop that we can run to move data to the appropriate tab if the value matches the name of the tab?
I do not have any current code, as anything I have tried using AutoFilter has not worked.
Thanks