In Access datasheet view, as you type data into your form and get to the end
of a row, a new row is added to allow the next record to be added. How would
I code excel to add rows as needed as the previous record is completed?

Also, I have information that I need to repeat automaticaly without user
intervention. On the first sheet I must list all the buildings at a location
including their street address (the address may be repeated several times).
On the next two sheets, I only need to list the addresses not the individual
buildings. How do i pull the unique records forward programatically (again
without having to train users how to copy and paste unique records).