I don't know how complicated or simple this is, but I urgently need a macro that does the following for 372 rows.
Copy one row, duplicate it (either into a new sheet or on the current sheet) so that there are now 4 instances of the row, then append different bits of text to the cell in the first column of each of these four rows (append "-43", "-6", "-8", and "-10" respectively).
I know I probably did a horrible job of describing that, so I have attached an XLSX book. The "Beginning" sheet is a very condensed example of what I have now. The "End" sheet is what it would look like after the macro has been executed.
Obviously, doing this manually to 372 rows would be very time consuming and I really need to have this done soon.
Thank you very very much to whoever can help!
Edit: I have also uploaded the example workbook as a XLS file.
Bookmarks