Macro Autofill

[sbrandt]

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!

[Trebor76]

Hi there,

Let me know if incorporating the following code into your existing macro does the trick:

Please Login or Register  to view this content.

HTH

Robert

[sbrandt]

That did it...thank you Robert!

[sbrandt]

Actually there's one strange thing here...even though the code you supplied specifies date format dd/mm/yyyy and the column is formatted the same way...when I run the macro it comes out mm/dd/yyyy. Any idea why it would do that?

[Trebor76]

Hi there,

Not really sure, but as it worked fine for me and considering I'm in Australia, I'd say it's to do with with your regional settings.

See if putting this line of code...

Please Login or Register  to view this content.

...immediately above this line

Please Login or Register  to view this content.

helps at all.

Robert