If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Copy data based on column header from one sheet to another sheet with added criteria

Thread starter abhirupganguli123
Start date Oct 22, 2019
Tags

column data detailed sheet summary

abhirupganguli123

Board Regular

Oct 22, 2019

Dear All,

Can anyone please help me with the VBA code for the below requirement ?

I have a workbook with few sheets in it. I want to copy data from "Detailed" sheet to "Summary" sheet according to some selected column heading in row 2 of the "Summary" sheet. The same column heading are available in "Detailed" sheet as well in row 3, but columns are more in Detailed sheet. Below are some additional criteria that need to be taken care of.

Criteria 1 - It should only copy data from the rows of the "Detailed" sheet which has the cell value "Sub Total" in column 1 of the "Detailed" Sheet.
Criteria 2 - After copying to "Summary" sheet, it should sort the "Summary" sheet data according to the last column value (currently column 7 as per my sheet).

If anyone can help me with the code, I will be really thankful.

Thanks,
Abhirup