I'm currently working with some data that needs to be broken for better viewing purposes and presenting to non-data minded people. It's going to be varied from week to week so lets just say that it will be around 200 lines of data with 11 columns per line. I want to break up the data based on 1 column that is tied to that product. there are 6 values that I need to break up into their own separate sheets. I want to build this into a template, so i can just dump my data into the main page every week and the data will populate on the specific pages it needs to go to.
can someone help please?
Auto. transfer rows of data to a new sheet based on 1 variable