Hi,
I have a sheet where data is being populated using SAP report. Once the data is populated, i have to copy data from the main area to another based on a filter selection and add the total Rows. As the rows are not fixed and SAP can populate the rows based on available records, I have to do this using macro.
Can we achieve this, I have attached the example sheet, help me.
if you see the example, data from sheet 1 is copied toexample.xlsx sheet 2 based on filter criteria Air Conditioners & Electrical Equipment
Any Kind of help is appreciated.
thanks,
ravi.
Bookmarks