Copying dynamic range to another column

[GSCCK]

Hi All,
I want to copy data from a dynamic range in a column (say column A) to another column (say H) without using macro.
Since the column H is used to create graphs and also used in formulae elsewhere, I cannot simply link the two columns as I want all the cells in the column H after the last data to be empty.
Data in Column A varies, and Column H should be able to adjust to the range automatically.

Appreciate any help

[martindwilson]

create a new dynamic range for h (you could use the length as the same criteria for col a)
in the cells put if(a1="","",a1)
cant help much further as i cant see your exact ranges

[GSCCK]

Thanks MartindWilson,
However, as I said, I cannot link the two columns like this. Data in the H column is used to generate graph and also used in formulae at other places. Once I put formula like (if a1="","",a1) in H column, graph start reading blank cells as well and gets messed up. Formula if (a1 = "", #n/a, a1) is no good either.
What I want is a totally blank cell after last cell data from Column A has been copied.
My data in Column A starts from Cell A8 and can go down to any cell. It has to be copied on Column H starting from H18.

[martindwilson]

not if you use a dynamic range in h i assume you have no blanks in data so
use something like
=H2:INDEX(H:H,COUNT(H:H)) as your dynamic range if you do have =na() for o/blanks from col A
=H2:INDEX(H:H,COUNT(H:H)+COUNTIF(H:H,"=#n/a"))
mind you why dont you just use column A for your source data anyway?