I work for an institution with 72 divisions. I create a document broken down with each division having its on worksheet. I have an index on the first page to go directly to the sheet they want. But some of our employees can't get back to the index easily. So I created a button to take them there.
How do I copy the button to each page without having to open each worksheet. Usually I copy somehting and hold the shift key, select all, then paste where I want it for all sheets, but with the copy/paste of the button excel says it can't paste the data. Any help is apprecitated.
Thanks,