I would like to create a macro that after the data is sorted and subtotaled,
it would go to a cell, for instance cost center, and all the cells and the
enitre rows that match that cost center be copied and added to a new
worksheet. I have created the macro to insert the new sheet and copy and
paste the data in the correct position by using the end up or down command,
but often the cells that are selected may include the wrong rows, especially
if there is only one cost center in that group. If I could write the macro
to recognize only the cost center number and select the cells based on that
number I believe all would work. I would like it to look at the first row of
the group after subtotalling and copy all the rows with that cost center.
Any help would be appreciated.