Our machine populates 15 columns worth of information for the 8 housing on the machine where our parts sit. The top row has the names for each column. The data on the last column (O) has always an integer value 1 to 8 identifying the housing. I want to copy a CSV file and paste it onto the sheet1. At sheet2 the same 15 column but only the rows contain “1” on the last column (O) without any empty rows between them and above them. Similarly, sheet3 only the rows contains the 2 on the last column without any empty rows between them and above them. I want to repeat this until the sheet9 for the 8th housing on the last column. Once the data is organized by the housing then I want to generate an Xbar Charts or scatter plots. I can do this manually but the goal is updating the chart automatically by just coping and pasting a CVS data so that a production supervisor can do it by himself and decides if the machine parameters need to be modified.

So far I tried IF command (=IF(Sheet1!$O5=1,Sheet1!O5,""))but I wasn't able to delete the empty rows. I tried to delete them with VBA but I wasn't able to do it since I don’t know VBA. I don't mind if there is an "update" button that we need to press on each sheet after coping and pasting a new data. I’ll really appreciate if you can help me the best way to do this project.

Best regards and thanks in advance,

Utku