Hi Freddie

not sure how to achive this, but are you pasting the SAME VALUE over all the
1000 records (ie updating "Dept" to "Department"), if so you can use the
visible cells only option with control & enter

.... try on a copy of your workbook

filter the data and select the column you want to replace, choose edit /
goto / special - visible cells, ok
now without clicking anywhere type the new value and press CONTROL & ENTER
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"freddie2711" wrote in message
...
I have a spreadsheet with 40000 records, I have filtered down to 1000
records
that have one coloumn of incorrect information that needs replacing, how
do I
paste the new data over the old?? What keeps happening is the new data
pastes over the first 1000 records, not only the filtered recorsds