Forum Discussion

Actug's avatar
Actug
Copper Contributor
Nov 02, 2019

Excel formula

Sheet 1 Cell A1 has date dec 1 2019 Cell A2 has a date Jan 1 2020 Need formula if A2 is later date than A1 then move to Cell A1 on Sheet 2 I am retried and forgot how to do this I am trying to hel...
Formulas and Functions
PReagan's avatar
PReagan
Bronze Contributor
Nov 02, 2019

Actug 

 

Attached is a sample workbook that contains a macro which moves adopted dogs from Sheet 1 to Sheet 2. Here is how it works:

 

Simply enter each dog's name into a cell in column A, the intake detail for each dog into a cell in column B, and the Date Adopted (only enter a date if adopted, otherwise leave blank) into a cell in column C. As soon as an adopted date is entered, the adjacent cell in column D will show "Adopted". Click the button labeled "Move Adopted" at the top of the page to move the adopted dogs from Sheet 1 to Sheet 2.

 

The macro searches for the value "Adopted" in each of the cells in column D. If the value "Adopted" appears, then the entire row in which it appears is copied to the next available row in Sheet 2. In addition, the row that is copied from Sheet 1 is removed.

 

Please let me know if you have any other questions.

Resources