Date and Data

W

Wayne Burritt

Hi: I was given the following code that works great adding today's date and
the value in D2. It adds to a progressive list. The problem now is that D2
no longer contains the data I want to list. Rather the data is now at
another sheet called "Trades" at cell B217. Can anyone help?

Thanks, Wayne

Range("B3").End(xlDown).Offset(1, 0).Value = Date
Range("C3").End(xlDown).Offset(1, 0).Value = Range("D2").Value
 
F

Frank Kabel

Hi
maybe
Range("C3").End(xlDown).Offset(1, 0).Value = _
worksheets("Trades").Range("B217").Value
 
Top