Hi All,

I am new to this forum so apologies if I am asking simple questions!

I have an urgent problem which I have been trying to code for weeks but unfortunately my VB skills at basic to put it kindly.

Excel version: Excel 2003

I have one workbook c:\Documents and settings\khilan.dhanani\Summary Weekly Report\Weekly Report.xls (master) which contains the following sheets:

Summary
Minor Works Projects
Optel T and T
Remote Asset
Control Telephony
Livelink service
.............etc there are 25 sheets in total

I then have separate workbooks which are distributed for update containing 1 worksheet for each project:

c:\Documents and settings\khilan.dhanani\Weekly Reports\Minor Works Projects.xls
c:\Documents and settings\khilan.dhanani\Weekly Reports\Optel T and T.xls
c:\Documents and settings\khilan.dhanani\Weekly Reports\Remote Asset.xls
c:\Documents and settings\khilan.dhanani\Weekly Reports\Control Telephony.xls
..............etc there are 24 workbooks in total

The main summary workbook (master) is password protected as are the sheets.

What I need is a macro which switches the protection of then loops through each workbook and copies the values only from each work book in the range of B2:N34 where the project names on the worksheets match. The reason why I only want the values copied is because the formatting is all held in the master spreadsheet and also each project feeds into the summary sheet and copying the who sheet new seems to break the link and formulas

So in simple terms in need the following

Where Workbook (master). Remote Asset = Workbook 3.Remote Asset then copy/paste (values only) range B2:N34

Hope that makes sense. I can upload a copy of the workbooks if needed.

Will really, really, really appreciate any help with this

Thank you in advance,

Khilan