Hello all,
I am struggling to find any help already posted about a macro to insert a row in this manner. What I need is to insert a single row in a spreadsheet, containing multiple worksheets, at a user defined location always in Column B of "Sheet 1". The sheet will be saved and opened a few days later and a new and completely random row will need to be inserted. One day I may need to insert a new row between Cell2 and Cell3 and save that document. Another day I may need to insert a row between the newly named Cell5 and Cell6. I will need to do this at random in a spreadsheet of about 500 rows. I have seen many Macros that allow other manners of inserting rows but never one like this. For example if it is possible to have excel have a pop up box to enter in the row name that would be excellent, or if I can have it look in a specific cell for a row location that would be great as well. I hope I provided enough information and welcome any help. Thank You!

Cell1
Cell2
Cell3
Cell4
Cell5
Cell6
Cell7
Cell8
Cell9