I am working with a VB code in an excel file, I have data in Sheet1 with several rows (now are 10,000, but could be more or less). In Sheet1 from column A to Column F are data that I want to copy and paste in other sheets (no formulas there are in sheet1), but Sheet1 have also Column G where data is categorized by series from 1 to X depending of how many lines because the data cannot be greater than 940 lines, in this sense in this example I have 11 series. What I want to do? I want to filter column G by series starting in series 1 until last series (11). For filter the series 1 in column G, I want to copy and paste the data in sheet1 from Column A to F to other sheet (could be labeled JV1), then when I filter column G by series 2, I want to copy and paste from A to F in other sheet (could be labeled JV2), then when I filter column G for series 3, I want to copy and paste from A to F in other sheet (could be labeled JV3), In each these sheets (JV1, JV2, JV3) the data from Sheet1 have to be copied in cell A20. My concern it is how can I do for that once I filter column G by each series, it will be copied in several sheets which must to be named as JV1, JV2, JV3......until last series in column G that now is 11?, Series in column G could be less or more than 11. I do not know if it can be coded using "while", "Do" FOR", etc. Any idea on this code will be appreciated.