G
Guest
Hi! Experts,
I need you'll again...please please help me...
We have data for 7 line of bussiness (LOB). There are two files File A &
File B. File A is a main data source which has data stored for each LOB on
different sheets that is file A has 7 sheets(all has a standard format) , i
am interested in 2 fields from File A--Date Received and Date Completed. File
B tracks the Turn Around Time for the job. following is the sample layout of
File B for 1 day like this i have it for the entire year--
Line of Bussiness TAT Goal Actual TAT Status
Arkansas 30 30 Y
Kansas 30 32 N
New Mexico 30 24 Y
California 30 27 Y
Illinois 30 7 Y
Utah 7 3 Y
Texas 30 12 Y
TAT Goal has default value say 30(in days) and Actual TAT calcultes and
display the difference between the 2 dates from File A and Status shows
whether we have met our goal or not.
Now I have created the formula for January 1, 2006 (for Actual TAT in file
B). now
January 1, 2006 will be on the same cell on all the 7 sheets. the formula
will has has the same cell name with the different sheet names.
Now is there something that can help me in copying this formula to rest of
the days with updated formula. because when i am copying and pasting it from
january 1 to january 2 same formula of january 1 gets copied in january 2 and
i have to make manual corrections to the formula to make it work the right
way.
i am sorry if you find it confusing...
can anyone please help...
I need you'll again...please please help me...
We have data for 7 line of bussiness (LOB). There are two files File A &
File B. File A is a main data source which has data stored for each LOB on
different sheets that is file A has 7 sheets(all has a standard format) , i
am interested in 2 fields from File A--Date Received and Date Completed. File
B tracks the Turn Around Time for the job. following is the sample layout of
File B for 1 day like this i have it for the entire year--
Line of Bussiness TAT Goal Actual TAT Status
Arkansas 30 30 Y
Kansas 30 32 N
New Mexico 30 24 Y
California 30 27 Y
Illinois 30 7 Y
Utah 7 3 Y
Texas 30 12 Y
TAT Goal has default value say 30(in days) and Actual TAT calcultes and
display the difference between the 2 dates from File A and Status shows
whether we have met our goal or not.
Now I have created the formula for January 1, 2006 (for Actual TAT in file
B). now
January 1, 2006 will be on the same cell on all the 7 sheets. the formula
will has has the same cell name with the different sheet names.
Now is there something that can help me in copying this formula to rest of
the days with updated formula. because when i am copying and pasting it from
january 1 to january 2 same formula of january 1 gets copied in january 2 and
i have to make manual corrections to the formula to make it work the right
way.
i am sorry if you find it confusing...
can anyone please help...