View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ferne ferne is offline
external usenet poster
 
Posts: 7
Default changing worksheet reference name when copying down cells

Thanks so much for your help. I have just started using more formulas but
couldn't put this together.

Thanks again!
--
ferne


"Jacob Skaria" wrote:

Rename 'Sheet' to 'Week'

--
Jacob (MVP - Excel)


"ferne" wrote:

I have a yearly summary worksheet by week. Each week i add the weekly report
to the workbook. I need a formula on the summary sheet that will change the
worksheet name when I copy it down. Is there any way to do this? Would send
a copy of my workbook but nowhere to attach it.
--
ferne