LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
freddie2711
 
Posts: n/a
Default paste over a filtered range

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Copy and Paste or Paste Special between Excel Workbooks wllee Excel Discussion (Misc queries) 5 April 29th 23 03:43 AM
Paste a named range to another range in Excel David Jean Excel Discussion (Misc queries) 2 April 13th 05 02:02 PM
How to paste INDIRECT function to range of cells? Mike Williams Excel Worksheet Functions 4 March 18th 05 03:02 AM
Conditional data validation (using a filtered range?) Simon Excel Worksheet Functions 0 February 15th 05 02:39 PM
How do I paste data into filtered list in Excel? DanBomb Excel Discussion (Misc queries) 3 February 2nd 05 10:49 PM


All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"