Posts by Redjohno


    Thank you but it is just copying the data. It needs to copy the customer for every instance there is a product. So 5 customers and 100 products there would be 500 lines if that makes sense? It would need to know when it reached the end also so that the amount of customers and products is essentially infinite.

    Hi Roy,

    Many thanks but thats not quiet what i was looking for.

    For the attached. Every product in B Sheet2 should appear on Sheet1 for the entire customer list. On the attached there are 35 customers and 16 products so the result should have 560 Entries on sheet 1. They should then ahve the correct price and dates from sheet2....



    I am hoping someone can help me with a script for the attached?

    On the data tab I could have any amount data so the script needs to work until it reaches a blank cell.

    Essentially, Column A (data) needs to be pasted into the load sheet column C for every instance there is a product in data column B. There could be 100 customer and 1 product or 100 customers and 10 products so there would be 1000 lines in this instance as there would be 100 * 10.

    The price then would need to be pasted for each product instance and the date requested into the load sheet as shown.

    I would need the grey cells on the load sheet un-edited.



    I'm struggling to figure this one out, hope you can help.

    I have a unspecified amount of data in column B starting from cell 7 and data in row 1 starting from D . What I am trying to achieve is to copy C into another sheet for every time there is a value in row 1. Once the values in row 1 have been finished it need to copy the next value in B and paste all of the values in row 1 again. It needs to do this until column C is empty.

    I've attached an example to help describe the scenario. Sheet one has the data, sheet2 is the output. As you can see y is coped for every x and repeated for the next x and so forth until no more data is in y.

    I hope this makes a small bit of sense!



    • sample.xlsx

      (17.09 kB, downloaded 14 times, last: )