| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find and replace help with copy paste
I have an excell sheet with 3500 cells on it. There is 161 cells scattered
thought with the word bicycle...How do i take those 161 results and paste them into a new worksheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find and replace help with copy paste
Are they all in one column? If so, you can use DataFilter.
Otherwise you would need a macro. But if all 161 cells contain just the word 'bicycle', then why not enter that word in a new worksheet and copy it 160 times? Or what other results did you want? Regards, Fred. "Alex43" wrote in message ... I have an excell sheet with 3500 cells on it. There is 161 cells scattered thought with the word bicycle...How do i take those 161 results and paste them into a new worksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i copy the values derived from find and replace? | Excel Discussion (Misc queries) | |||
| Find Copy and Paste | New Users to Excel | |||
| Find, copy and paste | Excel Discussion (Misc queries) | |||
| Where do I find A bell curve I can copy and paste | Charts and Charting in Excel | |||
| Macro to find, copy, and paste until value change | Excel Worksheet Functions | |||
Linear Mode
