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.
Are you saying that you want to replace the links with 0? Would you then want to toggle the links back on (difficult)?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I would be happy replacing them with 0, but optimally being able to toggle them back to their original values. Thanks for responding!
Posting Permissions
Reply With Quote
