| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Changes when data entered in referenced range
I have 5 formulas in a worksheet that refer to a range. When data is entered
in the range, the formulas adjust to exclude the cells with data. Range B5:B211 When data is entered in B5, range in the formulas becomes B6:B212. The workbook has nearly 200 worksheets with the same formulas. I'm working in Excel 2003. Does anybody have any idea what's going on????? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to toggle cells between display of referenced data. | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| Need formula to check values of data in several cells as criteria | Excel Worksheet Functions | |||
| What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions | |||
| Importing Data Into Formula Based Cells | Excel Worksheet Functions | |||
Threaded Mode
