I have a worksheet that we'll call "Main". I this worksheet, there are 12 columns.
Of those 12 columns, A thru L,
I need to separate them out into separate based on 20 distinct values that can appear (multiple times or none at all for each
value) in column B. (Note: If it would make it easier, I can re-arrange to make Column A the column with the criteria to sort
these by. It would be a pain, but I can do it.)
Based on what is in Column B, I need the workbook to be sorted
into the distinct subset workbooks, pulling only columns B, C, and G from the original. (The rest of the columns are used
elsewhere in the workbook for calculations, so I need them to stay in the "Main" sheet, but I don't need them in the subset
I further need it to not only sort these into individual workbooks based on column B, but also to only grab those rows that
have a set value ("2" in my workbook) in column J...even though column J is not itself one that needs to be copied
over...it's only a criteria determining what is copied.
Can this be done? I know I can do it with a combination of
If statement and Vlookup, but if I do it that way, then any rows that don't qualify to be sorted into a particular workbook
instead show up blank, so my data comes out with blank row, blank row, blank row, row with data (it qualifed with the
if/vlookup), blank row, blank row, data row, etc.
My "Main" sheet usually has somewhere around 1,000 rows, and I
have 20 different sheets to sort it into. I have to do this weekly, so I'm not inclined to sort/filter/copy/paste every time
I need the report published.
Any help will be greatly appreciated.
I can't post an example because I
don't have the necessary permissions to install anything (including the program to display worksheets) onto my computer. I
can send you an example if you'd like, as I know that's an incredibly complicated question...and more complicated with no