I created a Command button and need to assign a code to it. I have two sheets "Active" and "Archive". I have data in "Active" in cells B11:J33. This spreadsheet has a new entry button that adds rows whenever clicked so the cells will have data extending past row 33. I need a macro that begins with:
Private Sub CommandButton3_Click()
And I need it to be a button that when clicked, data that is over 90 days old is automatically put in the Archive sheet starting at B11:J11. I need column J to be what determines if the data is over 90 days old. That column is the Patient Notification Date. So if the date in that column is over 90 days old, then the entire row is transferred to the Archive section.
So here's the information I have:
I have data in B11:J33 right now but it will past row 33 when new entries are added.
When the date is over 90 days old, the entire row is transferred to the Archive page starting at B11:J11
Private Sub CommandButton3_Click()
And I need it to be a button that when clicked, data that is over 90 days old is automatically put in the Archive sheet starting at B11:J11. I need column J to be what determines if the data is over 90 days old. That column is the Patient Notification Date. So if the date in that column is over 90 days old, then the entire row is transferred to the Archive section.
So here's the information I have:
I have data in B11:J33 right now but it will past row 33 when new entries are added.
When the date is over 90 days old, the entire row is transferred to the Archive page starting at B11:J11
