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.
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.
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
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
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.
Ye s..in this case you are right..
So, would you like to upload a sample workbook??
I have attached my file. Hope you'll receve it.
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.
Many thanks for your answer, This evening I shall try the code.
Have a nice evening
Best regards
Sanasta![]()
You are welcome!
Nice evening to you, too!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks