Thanks for helping Roger, I realise I now have the reverse problem.( Sorry, I
realise I should have thought through this before but just learning now)

I think for my purpose, it will be better to move the data from spreadsheet
1 to spreadsheet 2.

For example the top rows of Spreasheet1 are Name of Site, PV's, UU's,
category, audience. The other spreadsheet has just Name of Site,PV's, UU's. I
need to update Spreadhseet 2 with the data from Spreasheet 1, so need to
move
category and audience data to move to spreadsheet 1 when the name of site
(column A text) is the same.... I should be able to do this after you told me
but am not successful. Please help.
--
Thanks
--
Thanks