how would I get it to go to monthly log sheet in correct areas?
Above red line is a daily sheet run with new information daily and below is a monthly sheet for all days of that month. thanks
Above red line is a daily sheet run with new information daily and below is a monthly sheet for all days of that month. thanks
examplesheet.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | DATE | |||||||||||
2 | (workbook1sheet3) | informationchangeseachday | 01-Oct-04 | |||||||||
3 | ||||||||||||
4 | TOTAL | 57 | 46 | |||||||||
5 | ||||||||||||
6 | ||||||||||||
7 | ||||||||||||
8 | MMYY | |||||||||||
9 | 1004 | (workbook2sheet1 | 2sheet1) | certaininformationsavedeachdaytothissheet | ||||||||
10 | ||||||||||||
11 | ||||||||||||
12 | ||||||||||||
13 | DAY | A | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | ||
14 | 1 | 57 | 46 | |||||||||
15 | 2 | |||||||||||
Sheet1 |