tjtsantos
10-03-2008, 04:21 AM
Hello Experts,
I may need your help again.
I am maintaining a single workbook. This workbook has 50 worksheets; each named differently. Within this workbook, the last sheet is named "Template". Now, each sheet in this workbook has a "Refresh" button that should copy all the contents of "Template" sheet to the current sheet where the "Refresh" button is clicked. How can I go about this such that I only have one code for each "Refresh" button on every sheet.
Hope you get the idea. Thanks a lot.
Tony
I may need your help again.
I am maintaining a single workbook. This workbook has 50 worksheets; each named differently. Within this workbook, the last sheet is named "Template". Now, each sheet in this workbook has a "Refresh" button that should copy all the contents of "Template" sheet to the current sheet where the "Refresh" button is clicked. How can I go about this such that I only have one code for each "Refresh" button on every sheet.
Hope you get the idea. Thanks a lot.
Tony