Thread: Looping and importing a macro?

Hi

I'm fairly experienced in Access VBA but only really read and altered Excel VBA. I wonder if you can help with some code:

I have a sheet that will have some correct data (a name) in cell A1. If there is data in column 2, I need a macro that copies/overtype the cell from A1 and continues until it finds column B has no more data. I have an idea of how to do this, but any assitance would be fantastic.

That would be a great start, however;

The sheets are already with the customers and have gone out without the macro. Is there anyway I can populate a return of sheets automatically with a macro? The only way I have thought is to copy the sheets in to a workbook with the macro in and save as - again, could this be automated?

It's the second bit that's really stumping me.

Do you have any suggestions?

Kind regards

Antony

Thanks for the help.