IF function in Excel refrencing data from another cell
Closed
carldavies75
Posts
1
Registration date
Saturday November 24, 2018
Status
Member
Last seen
November 24, 2018
-
Updated on Nov 25, 2018 at 01:14 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 4, 2018 at 11:17 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 4, 2018 at 11:17 AM
Related:
- IF function in Excel refrencing data from another cell
- Transfer data from one excel worksheet to another automatically - Guide
- Position formula in excel ✓ - Office Software Forum
- Number to words in excel - Guide
- Excel formula to subtract one cell from another - Excel Forum
- How to take screenshot in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Dec 4, 2018 at 11:17 AM
Dec 4, 2018 at 11:17 AM
Hi Carl,
Since today's date keeps changing, using the TODAY() function won't work. So I have provided you with a macro code:
I'm sure this won't solve your query, so let us now how we can further assist you.
Best regards,
Trowa
Since today's date keeps changing, using the TODAY() function won't work. So I have provided you with a macro code:
Sub RunMe()
If Range("A2").Value = Date Then Range("A3").Value = Range("A1").Value
End Sub
I'm sure this won't solve your query, so let us now how we can further assist you.
Best regards,
Trowa
