View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jared
 
Posts: n/a
Default changing a cell to changing the link

I have a cell refering to another workbook. example: April.xls
I want to change all cells with that refrence but without changing each one
individually, so i created a cell which i input the current month. How do i
link it to all other cells so instead of getting information from april.xls
it will get information from july.xls

examle formula:
=[April.xls]Sierra'!H7

how do i enter in this formula the cell no. instead of april?