I've looked through posts on named ranges, most are more advanced than the simple thing I want to do.
I have a named range on one sheet, and I want to show this as a reference on other sheets. I thought this would be simple, but maybe it's just not the way named ranges are used.
Attached is a sample spreadsheet. First tab shows the table defined; in practice it would be much larger. Second tab shows how I want it to appear. I see that I can do this by copying each cell reference. But what would be nice is to simply say "Put the named range block of cells right here."
Sorry if this is truly too fundamental. I thought there would be some built-in function to do this without having to write some VBA code to accomplish what seems to be a fundamental, simple thing.
I appreciate your taking a look at this.
Bookmarks