Hi,

I am preparing a template document for use within my organisation which will
be used to populate a monthly report.

The template has formula references to multiple Excel files that are
produced in monthly downloads from our systems.

I want to create a macro so that the user can enter the location of the
existing file in one cell (A2), the location of the new file in another cell
(B2) and then run a macro which does a find and replace of all instances of
A2 with B2. As part of the macro I also want it to update A2 with the data
from B2 and clear out the data in B2.
There are multiple links that will be updated so it would good to work out a
way that can update multiple links (e.g. A2 with B2, A3 with B3, A4 with B4
etc) in one go.

Could one of you good people help me out?

Thanks

Ed

Hi,

Anyone got any ideas on this?

Thanks

Ed

"edeaston" wrote:

Hi,

I am preparing a template document for use within my organisation which will
be used to populate a monthly report.

The template has formula references to multiple Excel files that are
produced in monthly downloads from our systems.

I want to create a macro so that the user can enter the location of the
existing file in one cell (A2), the location of the new file in another cell
(B2) and then run a macro which does a find and replace of all instances of
A2 with B2. As part of the macro I also want it to update A2 with the data
from B2 and clear out the data in B2.
There are multiple links that will be updated so it would good to work out a
way that can update multiple links (e.g. A2 with B2, A3 with B3, A4 with B4
etc) in one go.

Could one of you good people help me out?

Thanks

Ed