I have a excelfile with a dumb from our database. Each line has a status. I got 13 different statuses and got 300 lines with a status. I would like to make per status a new sheet and copy the lines with matching status to that sheet. Not all the data that is filled in needs to be copy only some cells need to come with. only row a,c,d,e,f,g,h,k needs to be copies to the new sheet.
it’s been a while since i’ve done this