one cell to generate multiple lines on a second sheet

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

Hi

Probably macro would be easiest. How about an example file so we can see what you are working with....


rylo