I have created a value for a range which i reference in a macro that
creates a pivot table. We add new data each month and generate a new
table so we needed to keep the range of cells dynamic.
Here is the definition for the name i use:
=OFFSET('C:\Monthly Stat Project\[I&RC Monthly Stats Count
TEST.xls]MonthlyCount_data'!$A$1,0,0,COUNTA('C:\Monthly Stat
Project\[I&RC Monthly Stats Count
TEST.xls]MonthlyCount_data'!$A:$A),6)
What i want to do is remove the reference to the location of the
workbook "C:\Monthly Stat Project\[I&RC Monthly Stats Count TEST.xls]"
and instead have it just reference the current workbook. Is there a
way to do this?
something along the lines of: =OFFSET(CURRENT WORKBOOK
MonthlyCount_data'!$A$1,0,0,COUNTA(CURRENT WORKBOOK
MonthlyCount_data'!$A:$A),6)
Any help would be greatly appreciated.
Thanks
--
captainwicked
------------------------------------------------------------------------
captainwicked's Profile:
http://www.excelforum.com/member.php...o&userid=36369
View this thread:
http://www.excelforum.com/showthread...hreadid=569980