| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i copy the values derived from find and replace?
I need to get a number of data entries from an Excel worksheet. I did a
"find" and came up with more than 1000 values. How can I copy the values all at the same time without doing a manual copying of each value/entry? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i copy the values derived from find and replace?
Are the values all in the one column. If so, try using AutoFilter and then
copy the visible cells. -- Regards, OssieMac "clem" wrote: I need to get a number of data entries from an Excel worksheet. I did a "find" and came up with more than 1000 values. How can I copy the values all at the same time without doing a manual copying of each value/entry? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i copy the values derived from find and replace?
After you set up your Find, click Find All and you will get a list with the
1000 values... press Ctrl+A to select them all and then close the Find dialog box. The 1000 items will all be selected... just Copy them, go to some other location and Paste them in. Rick "clem" wrote in message ... I need to get a number of data entries from an Excel worksheet. I did a "find" and came up with more than 1000 values. How can I copy the values all at the same time without doing a manual copying of each value/entry? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace a derived value with a label | Excel Discussion (Misc queries) | |||
| Find and Replace looking for values | Excel Discussion (Misc queries) | |||
| Copy Values in a cell (derived from formulas) | Excel Worksheet Functions | |||
| How do I copy cell values (derived from formula), not references? | Excel Worksheet Functions | |||
| How do I find and replace "values" (like #N/A) in a worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
