Hi,

I have a load of excel documents with exactly the same format that I want to change to a different format. Is there anyway of automating this process or do I have to go through and change each document manually?

For example each document may have "forename" in cell A1 and the value in A2 with no formatting and I want these values in the new sheet to be in B3 and B4 with "forename" in Bold and underlined.

Is this possible?

Many thanks