Forum Discussion
Actug
Nov 02, 2019Copper Contributor
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...
Actug
Nov 03, 2019Copper Contributor
PReagan
Nov 03, 2019Bronze Contributor
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.
- ActugNov 03, 2019Copper Contributor
Message
Cannot run the macro
The macro may not be available in this workbook or all macros have been disabled.
- PReaganNov 04, 2019Bronze Contributor
Go to File, Options, Trust Center, Trust Center Settings, Macro Settings, Select the box next to Trust access to the VBA project object model, click OK. You may have to close out of and reopen Excel.
- ActugNov 04, 2019Copper ContributorI will try tomorrow morning. Thanks