Splitting

[Ellasheba]

Hello
I have a project where I receive sheets from many different departments and need to be able to split each sheet up by a category and then copy that entire row entry across to a master sheet that adds in effect collates the information for that category....
I have found some VBA online, but am seeking advice for the best solution...
Thank you

 

[AlanSidman]

Sample worksheets shown with a mocked up solution would help greatly to provide you with a viable solution. PLease upload your samples so that we completely understand.

 

[Ellasheba]

Sample worksheets shown with a mocked up solution would help greatly to provide you with a viable solution. PLease upload your samples so that we completely understand.

Thank you AlanSidman, I am in the process of creating a spreadsheet to show what I am trying to achieve... I will repost later today...