Hello,

I did the record Macro thing, and yes it gives me a good idea...but I
am lacking the basic understanding of how to make it dynamic. Let me
paint the picture for you:

Each week I (or my team) forecasts sales on part number. The download
has the Calendar week updated for the current week. Depending on the
week, an new month could have started, so one of the months will no
longer be downloaded during the week. So basically, I need to find out
how I can identify name ranges and have the pivot table not be
constrictive to the exact data field names, rather on a reference of
cells.....I am probably not being very clear. Maybe some one has some
good internet links to help me get started.

Thansk,
Matt


--
matt4003
------------------------------------------------------------------------
matt4003's Profile: http://www.excelforum.com/member.php...fo&userid=9635
View this thread: http://www.excelforum.com/showthread...hreadid=561900