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.