Forum Discussion
Excel formula
Sheet 1
Dog's name in A1
I have dog's intake detail in B1
The adoption date in C1.
When dog is adopted I want to move A1 B1 and C1 to sheet 2. Is that possible. What I am trying to do it keep available dogs on sheet 1 and adopted dogs on sheet 2
Thanks for any suggestions
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.
- I will look at it after mass in the morning. Thank you so much. The non for profit is in the south and I am in Indiana. The software she was using was file maker pro and ex employee took software and neither of us know how to use it. She had customized it for the rescue. I only know Excel and making links. Nothing about macros. So thank you and I will communicate tomorrow. Good night
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!