none
Copy Range RRS feed

  • Question

  • I have the following table:

    Item   Jan  Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    prod1         4     3     1    6     9    12   4    2     5  12    1   0
    prod2
    prod3
    prod4

    And then I have another sheet with:

    prod1 010115
    prod1 020215
    prod1 020315
    prod1 010415
    prod1 040515
    prod1 010615
    prod1 010715
    prod1 030815
    prod1 010915
    prod1 011015
    prod1 021115
    prod1 011215
    prod2 010115

    so on

    so each product needs to be copied over the amount of months down and then copy the next item 12 times, etc etc from the table that shows months and product.

    Wednesday, December 17, 2014 7:42 PM

All replies

  • When you just want to copy the unique items from sheet 2 to sheet 1:

    Copy them all and remove the duplicates afterwards with the Excel build in feature.

    When the data in column B of sheet 2 should be filled into sheet 1:

    I have no idea how you created this results with your sample data. Please explain this in details.
    A sample filewould also be helpful.

    Andreas.

    Thursday, December 18, 2014 8:13 AM