Previous Topic Next Topic

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

Closed
JCoop - Jun 3, 2016 at 12:49 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jun 3, 2016 at 08:26 PM
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?

Related:

1 response

Answer 1 / 1
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Jun 3, 2016 at 08:26 PM
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.
0