Copying rows to a new sheet based on value in row G

[victoriabrown]

I am very new to VBA and am desperately trying to do something. I have a spreadsheet with several sheets. The first sheet is called Support Log and contains rows of data the other sheets are called "HART", "Athena", "Hotel" and "Internal". In column G there is a label of either "HART", "Athena", "Hotel" or "Internal"

I would like to copy the entire row to a new sheet of the same name for each of the labels. i.e. in the HART sheet I would like to be able to view all the rows from the Support Log sheet that have been labelled HART and then the same for Athena, Hotel and Internal.

It seems like it should be such a simple thing to do but I have read pages and pages of threads of other people trying to do similar things and have tried to modify the code but I just can't get it right! Can anyone please help me?

I thank you in advance for any help you can give!

[TMS]

I would like to copy the entire row to a new sheet of the same name for each of the labels.

Possibly a stupid question, but why do you want to do that. It's just duplication of data that may get out of sync. Effort for no return.

Why don't you just switch on Autofilter and filter on the label column? That way all the data stays in one place and you can filter it however you wish. You can also use Pivot Tables and Charts to Analyse the data.

Regards, TMS

[victoriabrown]

I suppose I could just do that couldn't I! Just making life difficult for myself it would seem! :p

[TMS]

What can I say?

If you really want to do it, you could still use Autofilter and then copy and paste the visible rows to a new sheet ...


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[victoriabrown]

Thanks for your help guys!