Tracking days and values

[khalil]

hi all

please help,

cell A1 always has a number changes once every day ,( only Cell A1)

i want to track that number with that date, i come back to it any time,

thanks

 

[jeffreybrown]

For testing purposes you can test the changes now and see if the value and date are pasting to the "Cancellations" sheets col A/B

There seems to still be a little misunderstanding on my part possibly. You stated earlier you want the list stored on another sheet, but you didn't mention anything about the value from N8 being on the same sheet. What are we to do with this value on N8? I'm sorry but I am missing something.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim oldvalue    As Long
    Dim Rng         As Range
    Dim LR          As Long
    
    oldvalue = Range("N8")
    Set Rng = Target.Parent.Range("N8")
    
    If Target.Count > 1 Then Exit Sub
    If Intersect(Target, Rng) Is Nothing Then Exit Sub
    
    With Sheets("Cancellations")
        LR = .Range("A" & .Rows.Count).End(xlUp).Row + 1
        .Range("A" & LR) = oldvalue
        .Range("B" & LR) = Date
    End With
    
End Sub

 

[khalil]

consider N8 is the cell were the value will be in, forget cell A1

and N8 is in the same sheet with column A/B were we are going to store

i did copy past the code, no results ! may be we need to wait for the date to change !

you are a good man
after solving this i have another challenging thread at least for me...I am still new in these threads.......it is exiting

 

[jeffreybrown]

You don't have to wait for the date to change to test.

Paste over the old value and see what results you get.

 

[khalil]

it works , thanks, since it is a test what shall i do now?


my other thread

Cell A1 D1 E1 contains formulas

they will give me results after filling other cells from the same row,
after getting results in those cells i want the formulas in them jumps automatically to
A2 D2 E2

and so on

i don't want to copy paste the formulas the old way...


thanks

 

[jeffreybrown]

Since it is just a test then delete out what's in col A/B and get ready for the real thing.

I see in your other post Smitty is helping you who miles ahead of me pertaining to anything in Excel.

Please keep your questions to that thread.

 

[khalil]

thanks a lot