Hi All,
Can you please help me to make a dynamic grouping sheet by Macro. If you look at my attached file, I have added one column (H) to calculate space before the first string and put conditional format on it. actually I'm trying to group whole the rows based on column'A', that's why I have added the column K. I don't know how to group them as it is shown on excel. beside I have copy and Pastethese data from P6. cause I need to do it every week, I'm looking for a dynamic and quick way with least admin time.
I would be really appreciate if you help me in this regard.
Can you please help me to make a dynamic grouping sheet by Macro. If you look at my attached file, I have added one column (H) to calculate space before the first string and put conditional format on it. actually I'm trying to group whole the rows based on column'A', that's why I have added the column K. I don't know how to group them as it is shown on excel. beside I have copy and Pastethese data from P6. cause I need to do it every week, I'm looking for a dynamic and quick way with least admin time.
I would be really appreciate if you help me in this regard.
Attachments

11 KB Views: 10