Forum Discussion
Excel formula
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.
Can you please describe the message that you are seeing? I reviewed the screenshot that you shared but do not see a message.
Additionally, is it ever possible that the intake date is later than the adopted date? If not, then the original file that I shared is designed to move all dogs that have been adopted (i.e. the adoption date is later than the intake date) from sheet 1 to sheet 2.
- My pleasure!