Macro - C&P into new tabs, depending on change in cell

[CRMTHB]

Hi,

I have a worksheet (sheet1) which I want to split out into new tabs, depending on what is in cell T2. So if Apples is in T2, T4, T28 etc, I want all those rows, plus row 1 to be copied and pasted into a new tab, called Apples.

However, I only want selected data to be moved - so rows with apples and bananas split into their own tabs, but not pears, lemon, mangos, oranges etc.

There would be more instances which I do not want to be copied, so it'd be easier if I listed those to be included, rather than list those to be excluded

Can this be done?

Thanks

 

[My Aswer Is This]

So if you select T23 and it has Alpha and you select T34 and it has Bravo and if you select T45 and it has Charlie the script will need to create three new sheets named Alpha Bravo and Charlie and copy the rows to those sheets.

So some how the script will need to know if those three sheets already exist.
And if not create them and copy the rows to those sheets.
Is that what your wanting?

 

[CRMTHB]

So if you select T23 and it has Alpha and you select T34 and it has Bravo and if you select T45 and it has Charlie the script will need to create three new sheets named Alpha Bravo and Charlie and copy the rows to those sheets.

So some how the script will need to know if those three sheets already exist.
And if not create them and copy the rows to those sheets.
Is that what your wanting?

Yes, that's correct. All the tabs will need to be created as new, none of them exist at the moment

 

[My Aswer Is This]

Thanks for that answer. I may need to let someone else help you. As if you select two cells with the same sheet name the script would have to create a new sheet the first time but not the second time.
And I'm not good at checking if sheet exist.
This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.