One of my suppliers has a delivery program of 13 products which can be further divided into rods, plates and tubes in al kinds of sizes and colors.
from this program i have made an extensive excel file with all the products. with prices etc, so when i get new pricings, i only need to change 1 table, and all product will be adjusted.
Now i have all the products listed completed, however i have only listed rod diameters or plate thickness. now i want this products to be duplicated in the possible legths and sizes, with the formulas in it, so i can use this sheet in case of any file changes as source file for my purchasing.
for the rods and plates there need to be approximatelty created 3 times as many linethis as current (15 sheets with 80 products. )