Hi,
I have a spreadsheet where after I click a button, I paste text to first blank cell of a column based on the option button selected. Depending on the option button selected, different cell text from Sheet 2 gets pasted to the first blank cell of Column K in Sheet 1 and filled down to as many used rows in Col L. Unfortunately, my IF statements work in such a way that when I copy and paste the first time, it works perfectly. As soon as I go to select another option button, the data that was already in the previously first blank cell of Col K gets overwritten by the new text. For example, the first blank cell in Col K is K6. When I select Option Button 19, the cell text in Sheet 2 Cell A3 gets copied to K6 for as many used rows as in Col L. Now when I select Option Button 20, the cell text in Sheet 2 Cell A4 gets copied to K6, instead of the first blank cell. Below is my code. Any help is truly appreciated!
Bookmarks