software

Working on an XLS s/sheet with over 10,000 rows. Have filtered one of the
columns and now need to change that data by pasting from another s/sheet (
the columns are the same size) However, when I try to paste the new data,
because the column is filtered, it seems to paste into the rows hidden
quot;behindquot; the filter as well. E.G my filtered column has 830 rows, the data
that I want to paste into it is also 830 rows ( I want to change the whole
column), but when I try to paste the data, it only pastes 27 rows ( because
it seems to paste to the rows that are hidden by the filter too).
Help??

Perhaps you should unfilter first?

--
Don Guillett
SalesAid Software

quot;Yuyusquot; gt; wrote in message
...
gt; Working on an XLS s/sheet with over 10,000 rows. Have filtered one of the
gt; columns and now need to change that data by pasting from another s/sheet (
gt; the columns are the same size) However, when I try to paste the new data,
gt; because the column is filtered, it seems to paste into the rows hidden
gt; quot;behindquot; the filter as well. E.G my filtered column has 830 rows, the data
gt; that I want to paste into it is also 830 rows ( I want to change the whole
gt; column), but when I try to paste the data, it only pastes 27 rows (
gt; because
gt; it seems to paste to the rows that are hidden by the filter too).
gt; Help??