campgrounds360
New Member
- Joined
- Aug 31, 2018
- Messages
- 3
Hello,
My road block is providing the correct cell link formula in a check box based on the following conditions:
What cell link formula can be used so that when I copy the "MASTER" spreadsheet the subsequent copies automatically apply check box cell link formulas as follows:
spreadsheet(2) formula is Sheet3!$AC3
spreadsheet(3) formula is Sheet3!$AC4
spreadsheet(4) formula is Sheet3!$AC5
spreadsheet(5) formula is Sheet3!$AC6
spreadsheet(6) formula is Sheet3!$AC7
spreadsheet(7) formula is Sheet3!$AC8
spreadsheet(8) formula is Sheet3!$AC9
Any direction would be greatly appreciated!
Thank You for your time.
My road block is providing the correct cell link formula in a check box based on the following conditions:
- I've created a spreadsheet called "MASTER" (spreadsheet(1)) where I have populated about 50 check boxes.
- Each check box has a different cell link to populate TRUE/FALSE values on a database in spreadsheet called "Sheet3"
- Example of one check box cell link formula: Sheet3!$AC2
- If my database on "Sheet3" contains 8 rows (rows 2:9), then I copy the "MASTER" spreadsheet 7 times
- Now I have 8 spreadsheets for the 8 rows of data
- My road block is that the check box cell link formula remains: Sheet3!$AC2 for all 8 spreadsheets.
What cell link formula can be used so that when I copy the "MASTER" spreadsheet the subsequent copies automatically apply check box cell link formulas as follows:
spreadsheet(2) formula is Sheet3!$AC3
spreadsheet(3) formula is Sheet3!$AC4
spreadsheet(4) formula is Sheet3!$AC5
spreadsheet(5) formula is Sheet3!$AC6
spreadsheet(6) formula is Sheet3!$AC7
spreadsheet(7) formula is Sheet3!$AC8
spreadsheet(8) formula is Sheet3!$AC9
Any direction would be greatly appreciated!
Thank You for your time.