vfilter

Hi Folks, I have this code below for selecting a column and splitting the rows of data into different worksheets dependent upon the value in the selected column. I have found that to make it work best, the data is better being without formatting (no autofilter, no dynamic table, no borders, no...

Hello I keep getting an error that I can't figure out why, I have been racking my brain for hours. I keep getting the auto filter of range class failed and all spelling is correct and there shouldn't be any problems. Here is my code. Sub SplitCodeFilterSheet() Dim wswb As StringDim wssh As...

Hi Friends, I have this data. A 1 A 2 B 3 B 4 I am creating new files based on first column.So for this purpose I am applying filter on 1st column (taking input from user) and then based on applied filter generating new files(in this case one file for 'A' and another one for 'B').Below is...

Sub Split() Dim wb As String Dim ws As String wb = ActiveWorkbook.Name ws = ActiveSheet.Name Vcolumn = InputBox("Please indicate which column (i.e. A,B,C,...), you would like to split by", "Column selection") Columns(Vcolumn).Copy Sheets.Add ActiveSheet.Name = "_Summary"...