|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 19th, 2010, 03:03 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing worksheet reference name when copying down cells
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 
|
|
#2
May 19th, 2010, 04:52 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing worksheet reference name when copying down cells
Yes, list you worksheet names in any Column and use INDIRECT.
-- Regards Dave Hawley www.ozgrid.com "ferne" wrote in message ... 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
|
|
#3
May 19th, 2010, 07:46 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing worksheet reference name when copying down cells
If your worksheets are named as Week1, Week2 etc; try the below and copy down
=INDIRECT("'Sheet" & ROW(A1) & "'!A1") If a sheet do not exist this will return an error; to handle that use the below version =IF(ISREF(INDIRECT("'Sheet" & ROW(A1) & "'!A1")), INDIRECT("'Sheet" & ROW(A1) & "'!A1"),"") -- 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
|
|
#4
May 19th, 2010, 07:46 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing worksheet reference name when copying down cells
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
|
|
#5
May 20th, 2010, 02:49 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#6
May 20th, 2010, 02:55 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing worksheet reference name when copying down cells
Thanks for your help
-- ferne "ozgrid.com" wrote: Yes, list you worksheet names in any Column and use INDIRECT. -- Regards Dave Hawley www.ozgrid.com "ferne" wrote in message ... 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 .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
