Distribute data from one sheet in several sheets according to values in column A

[Sanasta]

I have data in one sheet sorted by data in column A (Vehicles Reg No). I made subtotals but it is necessary each vehicle to be in different sheet with all data for it. I don't remember how to do this operation. Shall appreciate help.

[Fotis1991]

Hi

I think the simplest way for this is to use Auto filter(by column A) and then copy paste to the other Sheets.

Hope to helps you

[Sanasta]

Thanks Fortis 1991,
I do copy/paste operation each month but I think there is more automatic way, which to ease and speed this operation. After sort operation I make subtotals. The trucks can be hidden and only to see truck you are interested in, but my colleague in France wants them distributed in sheets so after I arrange all operations and make subtotals have to copy and paste 51 times in 51 sheets.

[Fotis1991]

Ye s..in this case you are right..

So, would you like to upload a sample workbook??

[Sanasta]

I have attached my file. Hope you'll receve it.

[Fotis1991]

Hi

I did not forget you but i was looking to my files and i could not find(until now) this.

http://www.ozgrid.com/VBA/item-worksheets.htm

I am not familiar with VBA solutions, but this is very good, for what are you looking for..

Hope to helps you.

[Sanasta]

Many thanks for your answer, This evening I shall try the code.
Have a nice evening
Best regards
Sanasta

[Fotis1991]

You are welcome!

Nice evening to you, too!!