Need Excel Macro to select an unknown, named table and convert it toa range

[Reepicheep]

I really appreciate any assistance you can provide. THANK YOU.

---------------------------


Every week, I get 5 different Excel workbooks that each contain 1
table only. The table is always named, but I can't be positive that
it's the same name constantly. The table always starts in cell A1. One
of the workbooks I receive contains 3 columns of data, and I delete
Column B because the data is irrelevant for my purposes. The other 4
workbooks only contain 2 columns of data, Column A data is always
eight numbers, and Column B is always a date dd/mm/yy.

I need to convert each table to a data range, select the data range
and rename that "Table1". The reason why is because when I get the 5
different Excel workbooks, the data range may be longer than the
table, and I want to capture all available data into a new table (I
don't know how to extend an existing table to the last filled row).

For instance, the table may be Row 1 through 10, but the data may be
from Row 1 through 15.

Once I am sure all the data is captured into a table, I add a few rows
of text. Then, I cut and paste the values into a new, larger Excel
workbook that aggregates all the data and sorts it.


-----------------------------------


Again, thank you very much.

David T. Young

 

[Don Guillett]

"If desired, send your file to dguillett1 @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."