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


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=561138