I have been successfully able to copy an entire row from one worksheet to another worksheet based upon a value that was in a cell in a particular column of a large worksheet using a VBA code. However, I am needing to take this to the next step by reviewing a column in a data set and sorting the data (entire row) from one sheet to multiple other sheets depending on the entry in the cell in a particular column.
For example:
1) I have a starting list that is represented as the "Combined" tab. The example is 10 items, my real list is in the high hundreds and even the thousands.
2) I have a set of other tabs that need the information separated into the respective tabs by the value in the "D" column titled "Color"
3) After some sort of VBA macro is run, the data will from the "Combined" d and the entire row will be copied to the respective tab. There is a specific tab for all values in the "Color" column.
Sort Macro Picture.png
Bookmarks