I'm trying to get around the issue of not being able to protect a worksheet with hidden and locked cells but still allow the table to grow as the user adds rows (as soon as you button it up the table no longer expands).
I'm trying to put a table on sheet1 where the user enters data (columns A-N) and receives their calculated results (columns O-Z). Those results come from a table on sheet2 which I'm hoping to hide and lock. The unlocked sheet will then just say =Sheet2!N1 rather than show the formula.
Problem is, how do I link table2 with the calculations to table1 with the inputs so that table2 grows at the same time table1 grows? I'm running a MacBook Pro and I don't seem to have the same features available in Windows.
I can set it up with several thousand rows copied down with formulas that start out with =if(Sheet1!A1-"","",Sheet1!A1) and then all the formulas, but that makes the workbook huge in file size (not emailable), plus it will break if they add more rows than I set up ahead of time.
Maureenn
I'm trying to put a table on sheet1 where the user enters data (columns A-N) and receives their calculated results (columns O-Z). Those results come from a table on sheet2 which I'm hoping to hide and lock. The unlocked sheet will then just say =Sheet2!N1 rather than show the formula.
Problem is, how do I link table2 with the calculations to table1 with the inputs so that table2 grows at the same time table1 grows? I'm running a MacBook Pro and I don't seem to have the same features available in Windows.
I can set it up with several thousand rows copied down with formulas that start out with =if(Sheet1!A1-"","",Sheet1!A1) and then all the formulas, but that makes the workbook huge in file size (not emailable), plus it will break if they add more rows than I set up ahead of time.
Maureenn