Frank

I wonder if I might ask a further question ? Can the code be writte
such that it refers to a named file which lists out all the items tha
need updating on the current spreadsheet.

I.e.

Start at current spreadsheet, line 1
Go to reference sheet and compare line 1 against the list in th
reference sheet and make changes as necessary.
Then go to line 2 and so on.... ?

Regards

Terr

--
Message posted from http://www.ExcelForum.com