I would like to write a macro that will eliminate some redundant work in our inventory spreadsheet.
Let's say that I enter info into columns A:G. And let's assume that I sometimes need to duplicate all that info onto the very next line, sometimes multiple lines.
I would like to have a specific cell somewhere on the worksheet (like cell H1) where the operator types the number of times they want to duplicate the last row of data on the spreadsheet (ex: 5). So, if they type "5" in the cell, and ran the macro, it would take the last row of data and copy/paste it 5 times starting with the next blank row. Is there code that can do this?