Display data of Named Range in another sheet

[karthicdasari]

HI I want to display data of named range in one sheet in to another sheet.
To explain it more... I have a named Range "ABC" in sheet 1 with 5 rows and 5 columns.
Now I want to display data of "ABC" in sheet 2 .

Can anybody can help me on this

[Mordred]

something like this:

Please Login or Register  to view this content.

This was not tested.

[Mordred]

I guess more specifically:

Please Login or Register  to view this content.

[Mortalis]

Is there a way to accomplish this without using VB?
I have a workbook set up as a measuring tool calibration log and on each worksheet I would like to enter work instructions "how to" that are entered once on a separate worksheet. I have the cells of the "how to" named "Vernier_Caliper" for example. Then I want to be able to display this named range on each appropriate worksheet. This would then allow me to make changes to the "how to" on the global page that would display on each of the appropriate worksheets without needing to go into each worksheet to make the update.

I tried using the code supplied in the thread and copied to the VB code sheet of sheet (1) but could get the named range of information to show up on the subject worksheet.

TIA
Kevin