autofill

  • Thread starter Thread starter christian
  • Start date Start date
C

christian

Hello Please help with a auto fill problem, I have a
simple formula of ='Week 2'!E48 in B3 and need to fill
down as follows ='Week 3'!E48 in B4
='Week 4'!E48 in B5 etc. However excel
fills as Week 2, E49, E50 Etc. How can I tell excel what I
need to do. Many thanks
 
Back
Top