I have a worksheet that is downloaded daily in excel. Because everyday it
adds new data at the end of the recordset I need to have a macro that will
change/add data as new records are added.

What I get from my broker look like this

Date, Stock, Quantity, Quote

What I add so it can moved to a database is

Date, Stock, Quantity, Quote, UID

The UID will always be the same. The width of the worksheet will always
remain the same it is the length that changes daily.