T

#### Tasha

I have a worksheet that has formulas looking up data from another worksheet

within the same workbook. The first worksheet is set up like thiscells not

included have other formulas in them)

E G L P

R

2009 2008 2008 Prior Month YTD

Prior Month YTD

MTD MTD YTD 2009

2008

docname docnum

column E current formula: =Admissions!K85

(K is August column on

Admissions Sheet)

column G current formula: =Admissions!K82

column L formula: =sum(Admissions!D82:K82)

column P formula: =sum(Admissions!D85:J85)

column R formula: =sum(Admissions!D82:J82)

each month I am adjusting the formulas over one column to change it to

lookup the current months data, so for instance, in column E, for September's

sheet I would change the formula to =Admissions!L85, column L's formula, I

would change to =SUM(Admissions!D82:L82), etc.

Is there a vlookup or sumproduct formula I can use to accomplish this? I am

spending so much time manually changing formulas for up to 200 lines each

month.

The second worksheet is set up like thiswe don't use 2007 #'s)

D E F G H I

J K etc

JAN FEB MAR APR MAY JUN JUL AUG

phyname 2007 1 5 2 4 1 3 6 2

phyno 2008 6 1 3 2 1 5 3 1

phyno 2009 4 4 2 1 2 4 1

I know this is a lot to look at, but I have tried to think of a way to do

this, but

haven't been able so far to find anything. Any help you can give me would be

terrific!!!!