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