Hi All

I am in desperate need of a VBA genuis for a bit of work im doing. I currently have 73 spreadsheet which are updated on a weekly basis. All the spreadsheets have a week number of the year, 1, 2, 3, 4, 5 etc

I am looking for some code to locate a selected week number, for the code to search all 73 spreadsheets and bring back rows which have numeric data within range: D:H. from all the 73 spreadsheets.

I would really really apprecciate some help...

Hope this makes sense.

Thanks

Andrew