Auto. transfer rows of data to a new sheet based on 1 variable Closed

Question

Hello, 

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?

Configuration: Windows 7 / Chrome 50.0.2661.102

vcoolio · Answer

Hello JCoop,

Have a look at the following recently solved thread:-

https://ccm.net/forum/affich-900215-creating-master-spreadsheet-for-mailing-information#p900993

In particular, go down to post #9 as you'll see a code there that should work for you also. In the same post, there is a link to my test work book should you want to see the code at work.

Let us know what you think.

Cheerio,
vcoolio.

Auto. transfer rows of data to a new sheet based on 1 variable

1 response

Similar discussions

Subscribe To Our Newsletter!