automatically insert row each time a code changes

[Brian Rapuling]

I have a spreadsheet containing data in various columns and consists out of
about 18000 rows. Data is a hierarchy of Commodity structures starting from
the highest level etc. I want to automatically insert a row after each change
of code of the highest level

 

[Barb Reinhardt]

THis can be done. You'd need to use a Worksheet_Change event. Without
knowing the details of how you determine the "highest level" code or where it
might be located on the sheet, I can't give any more details.

You can read more about events here.

http://www.mvps.org/dmcritchie/excel/event.htm