J
Jonfin
I have an Excel file that is a summary file of select pieces of dat
from 40-60 other Excel subsidiary files. Every month we add a few ne
files that need to be added on to this summary tab.
The thought process I was using was to do a macro that takes a row o
data linked to a template, copy & paste the row, then replace the link
on the new row from the template file to the newly created file.
I am trying to figure out a simple (BY SIMPLE I MEAN VERY SIMPLE) wa
for people in my group to be able to replace this link. I have create
a macro that does all of the steps (including an input box for them t
enter the new file name) EXCEPT, I cannot figure out how to replac
with a new file name.
Is there a way to do something like Find: s:\template.xls
Replace: =A
Please help me
from 40-60 other Excel subsidiary files. Every month we add a few ne
files that need to be added on to this summary tab.
The thought process I was using was to do a macro that takes a row o
data linked to a template, copy & paste the row, then replace the link
on the new row from the template file to the newly created file.
I am trying to figure out a simple (BY SIMPLE I MEAN VERY SIMPLE) wa
for people in my group to be able to replace this link. I have create
a macro that does all of the steps (including an input box for them t
enter the new file name) EXCEPT, I cannot figure out how to replac
with a new file name.
Is there a way to do something like Find: s:\template.xls
Replace: =A
Please help me