ADVERTISEMENT
Thanks but I am having trouble. How do you do the sort?
any problem with this ?select all data including new column + data where you want to insert rows
sort the data (menu data / sort)
yes, it was clearHere is how I have the data: I would like to insert 12 rows between item 7100 and 7111 and then 12 rows between 7111 and 7122 and then 12 rows between 7122 and 8888 etc. In total there is 700 items in this spreadsheet.
column A
Item #
7100
7111
7122
8888
ADVERTISEMENT
why not try out ?sort on which column? column a b or c?
the number of inserted rows is independent of the number of datarowsIf you have more than 10 rows of data then you will be inserting more than 3 rows. I have 700 rows of data. I think I get the logic of what you are trying to do