Hi
I amtrying to learn VBA on my own and am making slow progress. I have been
tasked with creating a macro and I am not having any luck. This is the
scenario... There are daily spreadsheets that are stored as

G:\\Mypath\DailyMMMYYY\yymmdd.xls

At the end of the month I need to create a summary worksheet that looks at
row 10 on each daily sheet and and if the value is not "DOG" then I need to
copy the value of Row 7 of the same column to the summary sheet. The values
need to be copied to the summary sheet in a columnwise fashion. The number
of columns for each day may vary so I need to look at the entire row. I only
need the value in row 7 on the summary sheet.

Thanks!
Jodi