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

Report
-
Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
-
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?

1 reply

Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
230
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!