| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help using a cell ref. to go to another page for data
I have a cell that will put a page name in the cell depending on what day of
the week that it is. I have another page that I want data to populate in depending on the day of the week. what I want is something like this... =(from sheet listed in cell A1 is)(cell range on that sheet) day of week name of emp I have names of employees that will be working on certain days, depending on what day it is, I want the employee name to populate in the spreadsheet Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help using a cell ref. to go to another page for data
Take a look at the INDIRECT function in Help.
-- HTH Bob Phillips "justaguyfromky" wrote in message ... I have a cell that will put a page name in the cell depending on what day of the week that it is. I have another page that I want data to populate in depending on the day of the week. what I want is something like this... =(from sheet listed in cell A1 is)(cell range on that sheet) day of week name of emp I have names of employees that will be working on certain days, depending on what day it is, I want the employee name to populate in the spreadsheet Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to move my page break down below my last data cell entry | Excel Discussion (Misc queries) | |||
| Data in cell to reference a worksheet page | Excel Worksheet Functions | |||
| How do I move the data in one cell on a page to another page/cell | Excel Discussion (Misc queries) | |||
| When entering data into excel spreadsheet cell, the page just jum. | Excel Discussion (Misc queries) | |||
| excel fit to 1 page shows 1 page but not all data is on that page | Excel Programming | |||
Linear Mode
