I have a worksheet containing one column containing an indicator; A1, A2, B1, B2,... What would be the easiest way on getting all rows containing A1 into one worksheet/workbook, A2 into another ws/wb and so on?
What I would like to do is to get separate printouts for all rows containing A1, A2 and so on. The only way I know how to do it is just to filter on the column containing A1, A2,... and then printing each filter selection. In my case it would be extremely time consuming why I search for a way to separate the information set in one simple operation allowing separate print outs. I don't know how to write my own macros.
/Mikae
What I would like to do is to get separate printouts for all rows containing A1, A2 and so on. The only way I know how to do it is just to filter on the column containing A1, A2,... and then printing each filter selection. In my case it would be extremely time consuming why I search for a way to separate the information set in one simple operation allowing separate print outs. I don't know how to write my own macros.
/Mikae