I use some code to update data on a daily basis. It copies data from one tab and pastes to another. To determine what row I want to paste to I use this code
this by the way is a snippet
Worksheets("Booking Data").Activate
wkno = Format(Sheets("Input").Range("O6"), "DD/MM/YYYY")...