sheet referencing

I have multiple sheets in my spreadsheet, all named for each of the U.S. states. I'm trying to write a formula that will sum values on the corresponding state page once the user types in a state in cell A2. For example, I have states Alabama through Wyoming, I want to look through every state's...

I am trying to get a sheet reference name in a formula updated based on the previous sheet's name. I am trying to get this to work is a Do While Loop. Also within that loop, I am creating a set number of new sheets. Each new sheet should reference the previous sheet. Attached is the macro that I...

Hi! I have a problem with "global" cell references and named formulas when used with conditional formatting. I have several sheets where I use conditional formatting to highlight cells where a cell is empty. I use the same formula for several sheets, so I thought it would be a good idea to use...

Hello, I have very big problem and i can't find answer for it. Maybe You can halp me. 1. In Sheet "Intro" I have row (5), in wich are formulas: (i) C5(='Sheet1'!$A$1); (ii) I5(=OFFSET('Sheet1'!$A$1;17;1;1;)); (iii) In this row also is number of my tables line, i. e B5(=1). This number "1" is...

Hi there. I want to be able to change to a worksheet within my workbook depending on the value a specific cell shows. The cell in question has a validation list - each of the options to choose from are also names of worksheets in the workbook. When i press a command button, I want it to...