Macro - copy and insert multiple rows

Hi,

That is my first thread. I hope someone may be able to help me.

I am trying to create a macro that breaks up data from one row into multiple rows while copying some of the other row's data. See the attached Excel file that has two spreadsheets – original data and desired output.

In my original data spreadsheet rows have some info while some of these rows have replacing codes (in columns M onward) which are neither #N/A nor zeros (highlighted). I will call them actual replacing codes. The max number replacing codes may be 25.

I want the macro to look at the number of actual replacing codes and then insert the same number of additional rows beneath the first row. There should be a separate row for each actual replacing code. If there are no actual replacing codes, no new rows should be added. The replacing codes should be added at the first column while info from B to K columns should be copied. The original M columns onward can be deleted or left for manual deletion.

If it is not too complicated then "Y" should be inserted at the L column of the desired output spreadsheet to indicate that this row was added and the same actual replacing codes that where inserted at the first column should be added in column. If it is too complicated please ignore this part.

The number of rows in the original data is not a fixed number so the macro should be able to recognize it. All cells are text (i.e not numbers).

Any suggestions would be greatly appreciated! Let me know if there are any questions and thanks for all those who will try and help.


Thanks much, Yoram

Hi John,
I've found a simple solution. I define column A and H as text ones before I invoke the macro.
Thanks so much,
Yoram