Previous Topic Next Topic

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
Hello,

I use the following formula to copy the value of a cell on a given date, however I want the value to remain there forever more not just the one day.

=IF(TODAY()=DATE(2010,1,31),$D$14,0)

any help appreciated

Thanks



3 responses

Answer 1 / 3
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Oct 26, 2010 at 06:17 PM
Can't you use >= instead of just =
Once today has passed it will always be true.
0
Answer 2 / 3
nephilim3uk Posts 11 Registration date Monday August 9, 2010 Status Member Last seen October 27, 2010 1
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.
0
Answer 3 / 3
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
You disagreed with the decision facebook
MDHamijuddin -
HelpiOS -

1 response
Excel - IF function with multiple words
Nick -
user -

14 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses