R
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
---------------------------
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