I was working on an Excel 2003 file on a Windows machine, when the person for whom I was making this file told me they were going to use it on their Mac (using the Mac version of Excel 2008). This file has a tab called Data, and on this tab I created a named range called Database. This range is defined with a combination of OFFSET and COUNTA formulas so that as rows are added, the range automatically expands to include those rows.
When this file is opened on a Mac, the range Database still exists, and it is still defined with those dynamic formulas. However, when rows are added to the data, columns that contain formulas do not automatically copy down, and columns that contain list boxes are not automatically copied down. How do I fix this? I need for these formulas and list boxes to automatically copy down to each new record that's created. I'd very much appreciate some help on this. Thank you.
When this file is opened on a Mac, the range Database still exists, and it is still defined with those dynamic formulas. However, when rows are added to the data, columns that contain formulas do not automatically copy down, and columns that contain list boxes are not automatically copied down. How do I fix this? I need for these formulas and list boxes to automatically copy down to each new record that's created. I'd very much appreciate some help on this. Thank you.