Macro to repat the action of copying a cell

[Reevell]

I have 504 names in a spreadsheet that I need to create a file for on the D:\ drive. If I do it manually, I follow the steps of copying the name, go to my D:\ drive and select "creat new file" and then paste in the name of the person.

Is there anyway that I can create a macro to automate this and then stop once it has reached cell A504

Thx

Dave

[patel45]

yes, but explain better please, can you attach a sample file ?

[Trebor76]

Hi Dave,

Welcome to the forum!!

See how this goes:

Please Login or Register  to view this content.

Regards,

Robert

[Reevell]

Thanks for the reply. Extract of the File attached

[Trebor76]

Extract of the File attached

Just change the range in my solution from A1:A504 to I3:I506.

Robert