HOw can I paste data into a column with autofilter?
 

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
"behind" 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??

HOw can I paste data into a column with autofilter?
 

Perhaps you should unfilter first?

--
Don Guillett
SalesAid Software

"Yuyus" wrote in message
...
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
"behind" 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??