reference name

Hey Superstars, In a tab named "Schedule" i have a 'list' of text options (morning,afternoon,half day etc...). The source data for this in a sheet called "shifts". This has the shift (morning,afternoon) and then i have 2 additional fields (start and finish time). In the "hours" tab I have used...

Hello, is there a way to use a formula to reference a sheet name. example... =(F3-14)!a1 Where F3 is a date and by misusing 14, the resulting product would be a new date. This new date would be a sheetname from which you would reference and use cell A1

Hi, I'm working in excel 2002. I have a table of data in sheet1, and am trying to perform calculations across them in sheet2. The whole table of data is named all, the first column is named dates, then in sheet2 i have 2 cells specifying dates start and end. The calculations in the second...

Hi all, Here is my problem in a few lines. I have a lot of company models which I summarise in a separete spreadsheet. My problem is that whenever my boss updates the input spreadsheets, he changes the name of the spreadsheet (e.g. he moves from 'Company model 6.xls' to 'Company model 7.xls')...

I have a worksheet that in cell A2 has a list of names that is referenced though a data validation list on another sheet that has the data. The rest of the sheet uses Vlookup to reference the name selected to provide that persons information. There are some other static Vloookup information for...

Hi, When creating a PT in excel 2007 it gets a name. When I want to use that name in a formula (like vlookup) it does not appear in the list of names and functions that is auto populated as I am typing my formula. How can I get that name without typing it? Thanks, Tamir