I'm trying to make a "function" which accepts a source worksheet, target worksheet, and a unique "autofilter" value. The goal is to use the source worksheet and different target worksheets with different autofilter values to cut and paste the data seperated by the "unique" value. I can't get the function to work properly, it seems to error out saying "Run-time error '1004'" (Microsoft Office Excel cannot create or use the data range reference because it is too complex." The sheet has more than 65,000 lines (probably in the range of 68,000) and it will dynamically increase in the future as it is pulled from another data source. How can I make the data copy after column "G" is autofiltered? Column A:G from source sheet will go to A3,B3,C3,...G3 for only the visible data after the autofilter? I am using Excel 2007.

Please Login or Register  to view this content.