J
jmr4h8
I have 13 sheets, the first is a yearly and the other 12 represent the months
in the year. Data is first entered sequentially by date into the yearly
sheet. The yearly sheet is updated daily as the data is received. It is
then to be pulled apart, separated by into the appropriate monthly sheet for
further graphically analysis. I need this achieved using links.
The link formula I use for Jan. works create with the exception of having to
estimate how many rows will be needed. Hence the file size grows greatly
when you copy and paste the link formula across a range 1000 rows by 18
columns. This is the first thing I need to get around.
=IF(('Testing Reguest Log (2008)'!$E2>=Jan!$G$2)*('Testing Reguest Log
(2008)'!$E2<=Jan!$L$2),IF('Testing Reguest Log (2008)'!A2="","",'Testing
Reguest Log (2008)'!A2),"")
Jan!$G$2 is the first day of the month and Jan!$L$2 is the last day of the
month
Next thing to get around. Since the link to January worked, I copied &
pasted the same formula to Feb. and changed the criteria in the if
statements $E2>=Jan!$G$2) => $E2>=Feb!$G$2) and so forth. And everything
works great except; instead of the data beginning in row 3 it begins in row
45. and if its not obvious Jan contains 42 entries. The data in Feb starts
in the row where Jan left off. The formulas are getting the correct
information but I need a way to tell it where to begin.
Any ideas?
in the year. Data is first entered sequentially by date into the yearly
sheet. The yearly sheet is updated daily as the data is received. It is
then to be pulled apart, separated by into the appropriate monthly sheet for
further graphically analysis. I need this achieved using links.
The link formula I use for Jan. works create with the exception of having to
estimate how many rows will be needed. Hence the file size grows greatly
when you copy and paste the link formula across a range 1000 rows by 18
columns. This is the first thing I need to get around.
=IF(('Testing Reguest Log (2008)'!$E2>=Jan!$G$2)*('Testing Reguest Log
(2008)'!$E2<=Jan!$L$2),IF('Testing Reguest Log (2008)'!A2="","",'Testing
Reguest Log (2008)'!A2),"")
Jan!$G$2 is the first day of the month and Jan!$L$2 is the last day of the
month
Next thing to get around. Since the link to January worked, I copied &
pasted the same formula to Feb. and changed the criteria in the if
statements $E2>=Jan!$G$2) => $E2>=Feb!$G$2) and so forth. And everything
works great except; instead of the data beginning in row 3 it begins in row
45. and if its not obvious Jan contains 42 entries. The data in Feb starts
in the row where Jan left off. The formulas are getting the correct
information but I need a way to tell it where to begin.
Any ideas?