Hi everyone,

I have a workbook that I have set up with formulas, data validation, cond
formatting and macros. Now I need to make a copy of this in another language.
I have the translations set up in exactly the same cells in another workbook
(Source) so I thought the easiest option would be to copy ranges from Source
to Original (Destination). I need to paste as values because the destination
wkbk has conditional formatting.

There are 25 worksheets and the ranges are all odd row starting from 3 going
to between 20 and 25 covering columns A-M. There are a further 7 worksheets
with different information that would probably be easier to amend by hand.

If someone could help me to get started on this it would be brilliant. I was
wondering whether I could use input box to specify which sheets in each
workbook?

Thank you

--
Deirdre