Pleeeeeeeease Help...

It's a Saturday night, and I have the pleasure of being at work cause
of a serious deadline on Monday morn..

I have 200+ templates (all with different names) that need to have an
amendment made to them. The macro I have created to make all of the
amendments is saved within personal.xls.

I am stuck on one thing: There is a list of values used for validation
lookups contained within each template and they need to be replaced
(management have changed them!!). To make it even more interesting, in
several of these workbooks the values are different. However, the aim
is to update these values and make them all uniform.

I have typed the new values into a separate work book, as I though the
simplest way would just be to copy and paste the whole range from this
workbook (New Lists.xls) to the template.

Problem:
Issue is that with 200+ templates, I don't want to have to name the
workbook the values are to be pasted in to.

Hi Sue

Try this
http://www.rondebruin.nl/copy4.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Sue" wrote in message om...
Pleeeeeeeease Help...

It's a Saturday night, and I have the pleasure of being at work cause
of a serious deadline on Monday morn..

I have 200+ templates (all with different names) that need to have an
amendment made to them. The macro I have created to make all of the
amendments is saved within personal.xls.

I am stuck on one thing: There is a list of values used for validation
lookups contained within each template and they need to be replaced
(management have changed them!!). To make it even more interesting, in
several of these workbooks the values are different. However, the aim
is to update these values and make them all uniform.

I have typed the new values into a separate work book, as I though the
simplest way would just be to copy and paste the whole range from this
workbook (New Lists.xls) to the template.

Problem:
Issue is that with 200+ templates, I don't want to have to name the
workbook the values are to be pasted in to.