I have an excel 2007 template where the end user clicks a button and it populates A5 through C5 with one set of data. And then it populates G5 through I5 with another set of data. The number of rows varies everytime, A5-C5 may have 10 rows and G5-I5 may have 5 rows.
I want to be able to delete all the rows before adding new data whenever the end user clicks the button. Some users will press the button multiple times to get new data and I don't it to simply paste, I want to clear all the rows and then insert the new data.
Thank you in advance!