macro to run a macro for evrey cell in column depending upon valuein cell

[swaptul]

hi,
i am having an excel sheet used to inward the material.i have to enter its name size least count make id etc.I want a macro which will depending upon the details entered in the cell in column , open the respective file from a specified location i.e. network drive S:. i am using column A from 501 to 1200. it should not overwrite the previous file.
i think looping is required but unable to do that.
Please help me.
regards

[mongoose36]

This should get you started.

Please Login or Register  to view this content.