PDA

View Full Version : Toggle data



fatigued
09-28-2010, 01:16 PM
I have a set of workbooks that all link to a master consolidating worksheet, and I have been trying to create a switch of some sort on each individual workbook that would allow me to toggle between the data entered and zeroes to replace the data. If anyone can help I would appreciate it very much. Thanks.

Bob Phillips
09-29-2010, 12:13 AM
Are you saying that you want to replace the links with 0? Would you then want to toggle the links back on (difficult)?

fatigued
09-29-2010, 12:13 PM
I would be happy replacing them with 0, but optimally being able to toggle them back to their original values. Thanks for responding!