Update name range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CAM - 18 Jul 2007 05:35 GMT

Hello,

I have about 50 Excel files in a folder call "Import Updates". Within all
of the Excel files I have a sheet call "Table" The user will populate the
columns A - E each month. The number of rows varies, within the Excel sheet,
there is a name range call "DataImport". The user will update the range for
"DataImport" i.e A1:E20. My problem is many times the users does not update
the range. I would like to somehow update the "DataImport" range of all of
the 50 excel files within the "Import Updates" folder via a command button
and save the files automatically so I don't have to update all of the 50
excel files one by one. . Updating 50 excels files one by one is a pain.
Is this possible? Any tips will be appreciated. Thank you in advance.

Reply to this Message

Greg Wilson - 18 Jul 2007 06:12 GMT

If I understand you, you want a "dynamic named range". This is a named range
that uses worksheet formula within the range definition to define its
dimensions; typically a combination of Offset and CountA (or Count)
functions. See this link:

http://www.contextures.com/xlNames01.html#Dynamic

Greg

> Hello,
>
[quoted text clipped - 8 lines]
> excel files one by one. . Updating 50 excels files one by one is a pain.
> Is this possible? Any tips will be appreciated. Thank you in advance.

Reply to this Message

CAM - 18 Jul 2007 14:40 GMT

Thanks Greg I will take a look at it.

> If I understand you, you want a "dynamic named range". This is a named
> range
[quoted text clipped - 26 lines]
>> pain.
>> Is this possible? Any tips will be appreciated. Thank you in advance.

Reply to this Message

Rate this thread: