I am trying to set up a macro that will allow me to open up an excel template
from a folder from a tree of folders that will automatically prompt me for a
file path to fill in data from the file into the desired columbs and rows
necessary after i open the template so its just one open for me and then a
prompt. If anyone knows of a way to do this i'd appreciate whatever codes you
think might work the best. Also in this template there are multiple
sheets/workbook.