| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning a Worksheet Name to a Cell
Example, I want to add a new monthly data worksheet to by workbook and pull
all the present and past monthly data for a specific client. Currently the data is pulled through multiple vlookup functions and everytime I add a new sheet, I continuously need to manually change the functions worksheet reference. Is it possible to assign a cell with the new worksheet name and link that assigned cell to that function without manually changing each vlookup function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Assigning Range Names in one spreadsheet/worksheet | Excel Discussion (Misc queries) | |||
| assigning a value to a cell | Excel Worksheet Functions | |||
| If stmt and assigning a value to another cell | Excel Worksheet Functions | |||
| ASSIGNING A NEW NUMBER TO A WORKSHEET EVERY TIME IT IS OPEN | Excel Worksheet Functions | |||
| Assigning a value to a cell from a combox | Excel Discussion (Misc queries) | |||
Threaded Mode
