energizek
04-06-2010, 08:58 PM
Hi,
I have created a table shell on sheet2 of my workbook and I want a dynamic range (a column vector of varying length) from sheet1 to populate column A of the table shell in sheet2. The problem is that the length of the range is dynamic (there may be 20-200 rows of data) and in many cases I need the table shell in Sheet2 to expand (insert rows and maintain formatting) to accomodate the dynamic list.
How can I copy and paste a dynamic list between worksheets and have Excel automatically expand the number of cells to fit my needs?
Thanks!
Katie
I have created a table shell on sheet2 of my workbook and I want a dynamic range (a column vector of varying length) from sheet1 to populate column A of the table shell in sheet2. The problem is that the length of the range is dynamic (there may be 20-200 rows of data) and in many cases I need the table shell in Sheet2 to expand (insert rows and maintain formatting) to accomodate the dynamic list.
How can I copy and paste a dynamic list between worksheets and have Excel automatically expand the number of cells to fit my needs?
Thanks!
Katie