Merging the same Named range from multiple workbooks

[EliseFreedman]

Hi There

I am building an excel based system whereby users open up a spreadsheet for their area and score a number of different KPIs for high risk activities. They subsequently click a button and all the KPIs which are non compliant are extracted to an action plan spreadsheet. This all works fine but we now want to expand it so that the action plan from each Area is merged into one worksheet in another workbook. I have created a named range for the area action plans. This named range is the same in each worksheet - Action Plan and is as follows

(=OFFSET('Risk Management Action Plan'!$A$3,0,0,COUNTA('Risk Management Action Plan'!$A:$A),13)

The named range works as expected but I am not sure how to merge the named range from each sheet into another workbook.

I have tried searching on the web without any luck.

Can anyone give me some help

 

[SkipVought]

Elsie,

Why not merge these ranges together using MS Query? The resultset will be returned to a sheet. From that range you can easily do any lookup or other analysis.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}