Hello,
I am looking for help on a code to loop through sheets of data (the sheet names are dates listed in the column below labeled "Sheet Name".) I would like loop through each sheet that is a date and paste cell "D8" into column E in my table below for each corresponding date that has a Life of 5 in column D. For Each Date that has a Life of 7 I would like data from the sheets to be pasted in from cell "E8" into column E of the table below.
I would like this process above repeated above for column F of the table below, which would simply paste in data from "D9" and "E9" for each resepective sheet date and Life of 5 and 7. Any takers on this challenge would be appreciated!
<TBODY>
</TBODY>
I am looking for help on a code to loop through sheets of data (the sheet names are dates listed in the column below labeled "Sheet Name".) I would like loop through each sheet that is a date and paste cell "D8" into column E in my table below for each corresponding date that has a Life of 5 in column D. For Each Date that has a Life of 7 I would like data from the sheets to be pasted in from cell "E8" into column E of the table below.
I would like this process above repeated above for column F of the table below, which would simply paste in data from "D9" and "E9" for each resepective sheet date and Life of 5 and 7. Any takers on this challenge would be appreciated!
A | B | C | D | E | F | |
1 | AA | BB | ||||
2 | Path | Workbook | Sheet Name | Life | ||
3 | G:\Doc Files\Spread\ | Spread2011.xls | 1/7/2011 | 5 | ||
4 | G:\Doc Files\Spread\ | Spread2011.xls | 1/14/2011 | 5 | ||
5 | G:\Doc Files\Spread\ | Spread2011.xls | 1/21/2011 | 5 | ||
6 | G:\Doc Files\Spread\ | Spread2011.xls | 1/28/2011 | 5 | ||
7 | G:\Doc Files\Spread\ | Spread2011.xls | 1/7/2011 | 7 | ||
8 | G:\Doc Files\Spread\ | Spread2011.xls | 1/14/2011 | 7 |
<TBODY>
</TBODY>