NeverHappyMike
Member
Hi
I have many workbooks each with 5 specific worksheets (lots of people have their own workbook). I'm trying to collate the individual worksheets into 5 separate Master Workbooks (that I can work from). I'm having problems.
Within my colleagues workbooks I've assigned specific Named Ranges to the data area: $A$2:$I$43 is XXX1MyNamedRange. I thought I would then be able to refer to these ranges from my Master Workbooks (excel help, and common sense, says this would be possible).
My problem seems to be that unless the Master Workbook cell that I put the reference in is a cell that is included within the XXX1MyNamedRange it gives me #Value.
Example: Cell reference is in $A$2, $D4$, etc then it works. Celle reference is in $A$44 then I get value.
I'm trying to make a long list of the data: all the data is in the same format and covers the same rows and columns.
Any help, advice or better working practice for doing this would be appreciated (I am unable to export this data to an external database).
Many thanks
Michael.
I have many workbooks each with 5 specific worksheets (lots of people have their own workbook). I'm trying to collate the individual worksheets into 5 separate Master Workbooks (that I can work from). I'm having problems.
Within my colleagues workbooks I've assigned specific Named Ranges to the data area: $A$2:$I$43 is XXX1MyNamedRange. I thought I would then be able to refer to these ranges from my Master Workbooks (excel help, and common sense, says this would be possible).
My problem seems to be that unless the Master Workbook cell that I put the reference in is a cell that is included within the XXX1MyNamedRange it gives me #Value.
Example: Cell reference is in $A$2, $D4$, etc then it works. Celle reference is in $A$44 then I get value.
I'm trying to make a long list of the data: all the data is in the same format and covers the same rows and columns.
Any help, advice or better working practice for doing this would be appreciated (I am unable to export this data to an external database).
Many thanks
Michael.