Sheet 1Cell A1 has date dec 1 2019Cell A2 has a date Jan 1 2020Need formula if A2 is later date than A1 then move to Cell A1 on Sheet 2I am retried and forgot how to do this I am trying to help animal rescue as a volunteerThanks

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

Hello Actug, Can you please elaborate on what you mean by "Need formula if A2 is later date than A1 then move to Cell A1 on Sheet 2". Do you mean if the date in Cell A2 of Sheet 1 is later than the date in Cell A1 of Sheet 1 then you wish to select Cell A1 on Sheet 2? Or do you wish to move the date in Cell A2 of Sheet 1 to Cell A1 of Sheet 2?

Sorry didn't explain correctlySheet 1Dog's name in A1 I have dog's intake detail in B1The 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 2Thanks for any suggestions

Actug2HomeGeneral DiscussionClick here to refresh translationExcel formulaActugActug OCCASIONAL VISITOR36m agoSheet 1Cell A1 has date dec 1 2019Cell A2 has a date Jan 1 2020Need formula if A2 is later date than A1 then move to Cell A1 on Sheet 2I am retried and forgot how to do this I am trying to help animal rescue as a volunteerThanksLabels:Formulas and FunctionsAdd tags19 Views0 Likes2 RepliesAll topics2 RepliesPReaganPReagan replied to Actug22m agoHello Actug,Can you please elaborate on what you mean by "Need formula if A2 is later date than A1 then move to Cell A1 on Sheet 2".Do you mean if the date in Cell A2 of Sheet 1 is later than the date in Cell A1 of Sheet 1 then you wish to select Cell A1 on Sheet 2? Or do you wish to move the date in Cell A2 of Sheet 1 to Cell A1 of Sheet 2?Add tags0 LikesActugActug replied to Actuga minute agoSorry didn't explain correctlySheet 1Dog's name in A1I have dog's intake detail in B1The 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

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.

Excel formula | Microsoft Community Hub

12 Replies

Actug
Copper Contributor
Nov 02, 2019
Sorry didn't explain correctly

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
- 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.
  Actug - 11022019.xlsm36 KB
  - Actug
    Copper Contributor
    Nov 03, 2019
    PReagan
    
    This is a very simple sample. Hope this makes sense
    Adoptions.xlsx10 KB
PReagan
Bronze Contributor
Nov 02, 2019
Hello Actug,

Can you please elaborate on what you mean by "Need formula if A2 is later date than A1 then move to Cell A1 on Sheet 2".

Do you mean if the date in Cell A2 of Sheet 1 is later than the date in Cell A1 of Sheet 1 then you wish to select Cell A1 on Sheet 2? Or do you wish to move the date in Cell A2 of Sheet 1 to Cell A1 of Sheet 2?
- Actug
  Copper Contributor
  Nov 02, 2019
  
  Actug2
  Home
  General Discussion
  
  Click here to refresh translation
  Excel formula
  Actug
  Actug OCCASIONAL VISITOR
  36m ago
  
  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 help animal rescue as a volunteer
  Thanks
  Labels:
  Formulas and Functions
  Add tags
  19 Views0 Likes2 Replies
  All topics
  2 Replies
  PReagan
  PReagan replied to Actug
  22m ago
  
  Hello Actug,
  
  Can you please elaborate on what you mean by "Need formula if A2 is later date than A1 then move to Cell A1 on Sheet 2".
  
  Do you mean if the date in Cell A2 of Sheet 1 is later than the date in Cell A1 of Sheet 1 then you wish to select Cell A1 on Sheet 2? Or do you wish to move the date in Cell A2 of Sheet 1 to Cell A1 of Sheet 2?
  
  Add tags
  0 Likes
  Actug
  Actug replied to Actug
  a minute ago
  
  Sorry didn't explain correctly
  
  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

Forum Discussion

Excel formula

12 Replies

Resources