Copy cell value on a given day.
Closed
nephilim3uk
Posts
11
Registration date
Monday August 9, 2010
Status
Member
Last seen
October 27, 2010
-
Oct 26, 2010 at 07:30 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 28, 2010 at 10:36 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 28, 2010 at 10:36 AM
Related:
- Copy cell value on a given day.
- Hay day download pc - Download - Simulation
- If a cell has text then return value ✓ - Excel Forum
- Time of day clock stopped - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- You can't access certain settings for a few days instagram - Instagram Forum
3 responses
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Oct 26, 2010 at 06:17 PM
Oct 26, 2010 at 06:17 PM
Can't you use >= instead of just =
Once today has passed it will always be true.
Once today has passed it will always be true.
nephilim3uk
Posts
11
Registration date
Monday August 9, 2010
Status
Member
Last seen
October 27, 2010
1
Oct 27, 2010 at 03:00 AM
Oct 27, 2010 at 03:00 AM
No because the value changes on a daily basis.
The sheet calculates total events daily and subtotals them monthly then refreshes every 30 or so days, so I want to capture the total events at the end of each month for comparison to other months.
The sheet calculates total events daily and subtotals them monthly then refreshes every 30 or so days, so I want to capture the total events at the end of each month for comparison to other months.
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Oct 28, 2010 at 10:36 AM
Oct 28, 2010 at 10:36 AM
Can you try this macro? It will run whenever you open the spreadsheet.
Sub Workbook_Open()
' Put the value from D14 into A1 when today equals the date specified
If Date = "10/28/2010" Then Range("A1").Value = Range("D14").Value
End Sub
Sub Workbook_Open()
' Put the value from D14 into A1 when today equals the date specified
If Date = "10/28/2010" Then Range("A1").Value = Range("D14").Value
End Sub
