C
comotoman
I ahev a workbook with 20 sheets in it, all template forms for completed
jobs. On the first sheet I have the date in cell a2. b4 back dated 1
year from a2. I need to lookup cells c2:d2{(merged)this is a completion
date}. in all the 19 remaining sheets and show the date if it is within
the month back dated 1 year.
sheet 1 a2= "September 30, 2005" with formula (=today())
sheet 1 b4= "September-04" with formula (=a2-365)
sheet 2 c2:d2="September 30, 2004"
or the same as above only in sheet 19.
the fromula i have now is =VLOOKUP(B4,'Job 1'!C22,TRUE) and it works
for one sheet, i need it to lookup all 19.
jobs. On the first sheet I have the date in cell a2. b4 back dated 1
year from a2. I need to lookup cells c2:d2{(merged)this is a completion
date}. in all the 19 remaining sheets and show the date if it is within
the month back dated 1 year.
sheet 1 a2= "September 30, 2005" with formula (=today())
sheet 1 b4= "September-04" with formula (=a2-365)
sheet 2 c2:d2="September 30, 2004"
or the same as above only in sheet 19.
the fromula i have now is =VLOOKUP(B4,'Job 1'!C22,TRUE) and it works
for one sheet, i need it to lookup all 19.