Good day,

I am using Excel to generate a CSV file to load into a industrial cutting machine. The CSV file is used to import the cut list. As such formatting and the data per cell in Excel is important.

What I am presently trying to do is input the dimensions and type of the overall part and have the individual pieces be generated in a second sheet. I can presently do something of the sort using extensive 'if' statements. The problem with this is that I can only generate one line for every line I enter.

So this leads to what my problem is. I want to be able to have the info on 'Row one' 'sheet one' generate its parts list (which maybe 1-3 rows) and post that to sheet 2. Then 'row two' 'sheet one' generate it's info, but place it into the next unused row on sheet two. One of the issues I am having is that each row on sheet one may need to generate between 1-4 lines, maybe more, and I don't know how to not overwrite or have gaps on sheet 2.

I hope this makes sense. Am I looking at going into macros or learning VBA?

Thanks in advance,
Jordan