Update name range

[CAM]

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.

 

[Guest]

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

 

[CAM]

Thanks Greg I will take a look at it.

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