| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a cell ref. down a column, changing worksheet # along the | Excel Worksheet Functions | |||
| Copying a named range with a changing cell reference | New Users to Excel | |||
| worksheet copying, changing source link | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| Copying worksheet but changing format | Excel Discussion (Misc queries) | |||
Hybrid Mode
