I have below requirement:
i have a excel file with single sheet where there is data in 18 columns i.e. A to S starting from Row 3. Row 3 is header and actual data starts from row 4.
I need macro to do following activity.
Sort file on column B.
Column B comprises months-year combination say jan2020 or jan2019 etc
Now depending on column B value, i need data in separate sheet for each month-year combination. This data is dynamic in nature i.e. number of rows for each month-year combination may change and number of month year combinations may change as well. Name of new sheet should be as per column B month-year combination for which data is copied.
Data to be transferred is from column C to R in new sheet from Row 2 (A2:P) and in A1 cell of new sheet to have value as per column S equivalent in sheet1 (source sheet). I have attached screenshots below for refrence.
Original sheet:
Added sheets:
1.
2.
3.
Thanks
Tumbad
i have a excel file with single sheet where there is data in 18 columns i.e. A to S starting from Row 3. Row 3 is header and actual data starts from row 4.
I need macro to do following activity.
Sort file on column B.
Column B comprises months-year combination say jan2020 or jan2019 etc
Now depending on column B value, i need data in separate sheet for each month-year combination. This data is dynamic in nature i.e. number of rows for each month-year combination may change and number of month year combinations may change as well. Name of new sheet should be as per column B month-year combination for which data is copied.
Data to be transferred is from column C to R in new sheet from Row 2 (A2:P) and in A1 cell of new sheet to have value as per column S equivalent in sheet1 (source sheet). I have attached screenshots below for refrence.
Original sheet:
Added sheets:
1.
2.
3.
Thanks
Tumbad