I created a worksheet with named cells and ranges and used a macro to
organize data within the worksheet. I then copied the sheet several times.
The named cells and ranges are valid for each separate sheet and the macro
runs independently for each active sheet using the same control keys. I've
been trying to add another range name that would be common to each seperate
worksheet that would be referenced by the macro just as the original cells
and ranges are, but the name becomes specific to the last sheet that the
name was defined on. How do I define names that apply to each sheet
independently. If I can't resolve this problem I will have to develop a
seperate macro for each worksheet in the workbook.