COpy paste worksheet

[tlindeman]

I am not sure this is possible. However, I need to copy a worksheet from an email and paste into my workbook each month. What I would like in Cell A1 is to show the date that I copy and pasted the worksheet. So many whenever cell A2 changes, show todays date. Also, could you please help me to set it up to run when I open my workbook ("Enterprise KPIS")

Thank You
Tony

 

[bensonsearch]

I am not sure this is possible. However, I need to copy a worksheet from an email and paste into my workbook each month. What I would like in Cell A1 is to show the date that I copy and pasted the worksheet. So many whenever cell A2 changes, show todays date. Also, could you please help me to set it up to run when I open my workbook ("Enterprise KPIS")

Thank You
Tony

well the date part is easy, just (this would go in the workbook open section)

Private Sub Workbook_Open()
thisworkbook.sheets("Sheet1").range("A1").value = date
 
'you would need something that tests the value in A2 has changed so 'maybe recording it to a cell that is out of the way and referring back to 'it.
 
thisworkbook.sheets("Sheet2").range("A1").value = thisworkbook.sheets("Sheet1").range("A2").value
 
If thisworkbook.sheets("Sheet2").range("A1").value = thisworkbook.sheets("Sheet1").range("A2").value then
 
'nothing
 
else 
thisworkbook.sheets("Sheet1").range("A1").value = date
end if
End Sub

 

[bensonsearch]

how did you go?