+ Reply to Thread
Results 1 to 8 of 8

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

  1. #1
    Registered User
    Join Date
    02-14-2012
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    4

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

    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.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

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

    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.

  3. #3
    Registered User
    Join Date
    02-14-2012
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    4

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

    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.

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

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

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

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

  5. #5
    Registered User
    Join Date
    02-14-2012
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    4

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

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

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

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

    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.

  7. #7
    Registered User
    Join Date
    02-14-2012
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    4

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

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

  8. #8
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

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

    You are welcome!

    Nice evening to you, too!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1