Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying to Clipboard query.
I need to copy a column of 40,000 numbers to the clipboard, using Excel as a database, carry out 12-15 sorts dropping the clipboard contents into vacant columns as I go. After I try a sort, the paste option no longer offers. Any explanation? please. |
#2
|
|||
|
|||
Hi Rodney,
take a look at Chip Pearson's page http://www.cpearson.com/excel/clipboar.htm you might want to clear the clipboard. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rodney" wrote in message ... I need to copy a column of 40,000 numbers to the clipboard, using Excel as a database, carry out 12-15 sorts dropping the clipboard contents into vacant columns as I go. After I try a sort, the paste option no longer offers. Any explanation? please. |
#3
|
|||
|
|||
G'day David,
I took a cursory look, but it seems archaic for my needs, a bit like a sledgehammer to crack a nut. I'll use a work around by pasting into an MSWorks WP doc (400 pages :) then paste special / text from there, it only takes a few seconds. Thank you very much for your time in answering my query. | Hi Rodney, | take a look at Chip Pearson's page | http://www.cpearson.com/excel/clipboar.htm | you might want to clear the clipboard. | --- | HTH, | David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] | My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm | Search Page: http://www.mvps.org/dmcritchie/excel/search.htm | | "Rodney" wrote in message ... | | I need to copy a column of 40,000 numbers to the clipboard, | using Excel as a database, carry out 12-15 sorts | dropping the clipboard contents into vacant columns as I go. | | After I try a sort, the paste option no longer offers. | Any explanation? please. | | | | | | |
#4
|
|||
|
|||
If you're using Excel 2002, or later version, you can paste the numbers
from the Office Clipboard. To view the clipboard, choose EditOffice Clipboard. After the sort, select another cell where you want to paste the data. Click on the item in the clipboard. Rodney wrote: I need to copy a column of 40,000 numbers to the clipboard, using Excel as a database, carry out 12-15 sorts dropping the clipboard contents into vacant columns as I go. After I try a sort, the paste option no longer offers. Any explanation? please. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Thankyou Debra.
I intend upgrading, so I'll retain your advice. In the interim, I'll employ MSWorks WP, the programs are siblings. Regards Rodney | If you're using Excel 2002, or later version, you can paste the numbers | from the Office Clipboard. | | To view the clipboard, choose EditOffice Clipboard. | After the sort, select another cell where you want to paste the data. | Click on the item in the clipboard. | | Rodney wrote: | I need to copy a column of 40,000 numbers to the clipboard, | using Excel as a database, carry out 12-15 sorts | dropping the clipboard contents into vacant columns as I go. | | After I try a sort, the paste option no longer offers. | Any explanation? please. | | | | | | | -- | Debra Dalgleish | Excel FAQ, Tips & Book List | http://www.contextures.com/tiptech.html | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
copying files with query(s), the query is still linked to the ori. | Excel Discussion (Misc queries) | |||
Excel2000 ODBC query oddity | Excel Discussion (Misc queries) | |||
Query of External Data | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |