Each day I copy a range of data from one spreadsheet into a larger sheet where all the data is kept on an ongoing basis. The data is copied beginning in column B. Then in column A I enter today's date and copy it down.

I've written a macro to copy the necessary range into the second worksheet, but can't figure out how to get the date entered only in the rows that are newly occupied.

Please help!