Hi guys
Is there a way to have my new entries written to row2 instead of the last empty row?
(sorry for the tittle errow- row1 has the column names, so the data would have to start at row2)
I am guessing it would have to insert a row above row2 to push the existing data down and write to the newly inserted top row.
I have a userform that collects the data and writes to the last empty row, but I guess it will be easier for the users to see the newest entries on top when excel opens since the list of entries is sooo long and will become very long as years go by.
This is my userform NextButton code that transfers the userform data onto the excel sheet.
Thanks in advance for all of your help!HTML Code:
Bookmarks