VBA: Copy and Paste

[knightofni]

Hello,

This is my first attempt at inserting HTML into a post so I hope I've done it correctly!


I need to do the following:

• Open project workbooks using the details in column A (there are 53 files that need to be open and are all stored in separate folders, they are project documents so cannot be combined into one mass folder)
• Look for "@" in cell H1 in the newly open workbook
• If present return "Complete in" Master Workbook column B then,
• Copy a range in the open project workbook and paste into range in Master Workbook. Finally,
• Close project workbooks.

I have tried numberous different Open, Copy and Paste codes I've found in forums but none seem to work and I feel as though I am stuck in a continual loop!

Any assistance that could be provided would be greatly appreciated.

Many Thanks

Excel Workbook
	A	B	C	D	E
1	File Location	PID Complete?
2	\\Server\Subfolder1\Subfolder2\Subfolder3\Subfolder4\Supfolder5\File.xls	1
3
4
5
6
7
8
9
10
11
12
13	Action	Start Date	End Date
14
15
16
17
18
Combine Sheet

Excel 2003