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.