I am importing data into Excel. I need to have that data duplicated in a
worksheet of another workbook and have it updated when I open the workbook.
Is there a way to create a link or some other mechanism that will accomplish
this task?

Also, I need to create a dynamic cell reference. That is it refers to the
last column of the last row that contains data. This reference will change
as I add data to the worksheet. Thank you in advance for your assistance.

For the first point, you may link the data using on the second sheet the menu
option Data-Import External Data-Import data, and selecting the first book
as the origin of the data. That will give you the option to refresh the data
on the second workbook.
For dynamic references, you may use dynamic named ranges. The examples on
this page refer to full ranges, but you may adapt them to your needs:
http://www.ozgrid.com/Excel/DynamicRanges.htm

Hope this helps,
Miguel.

"SJT" wrote:

I am importing data into Excel. I need to have that data duplicated in a
worksheet of another workbook and have it updated when I open the workbook.
Is there a way to create a link or some other mechanism that will accomplish
this task?

Also, I need to create a dynamic cell reference. That is it refers to the
last column of the last row that contains data. This reference will change
as I add data to the worksheet. Thank you in advance for your assistance.

Miguel,

Thank you kindly.

"Miguel Zapico" wrote:

For the first point, you may link the data using on the second sheet the menu
option Data-Import External Data-Import data, and selecting the first book
as the origin of the data. That will give you the option to refresh the data
on the second workbook.
For dynamic references, you may use dynamic named ranges. The examples on
this page refer to full ranges, but you may adapt them to your needs:
http://www.ozgrid.com/Excel/DynamicRanges.htm

Hope this helps,
Miguel.

"SJT" wrote:

I am importing data into Excel. I need to have that data duplicated in a
worksheet of another workbook and have it updated when I open the workbook.
Is there a way to create a link or some other mechanism that will accomplish
this task?

Also, I need to create a dynamic cell reference. That is it refers to the
last column of the last row that contains data. This reference will change
as I add data to the worksheet. Thank you in advance for your assistance.