Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pasting values
I am working on a template which evaluates all the markets in which we do
business in. I have information on the some of the markets but not all of them so i have filtered by NonBlanks so display all of the valid information. I now have found new information on the countries that have NonBlank and would like to paste them to my sheet as they are in the same order of my filtered template. However, when I paste the information it disregards the filter and pastes it on the sheet containing all the data. Naturally, the information is not pasted in the right cells. I have gotten around it by copying the filtered template into a new sheet however now i would like to populate my original template but I am encountering the same problem. I hope that this is clear. Thank you very much in advance, laurent |
#2
|
|||
|
|||
There's nothing built into excel that lets you do this.
If it's possible, can you paste to the bottom of the list, then sort the list? Steiner wrote: I am working on a template which evaluates all the markets in which we do business in. I have information on the some of the markets but not all of them so i have filtered by NonBlanks so display all of the valid information. I now have found new information on the countries that have NonBlank and would like to paste them to my sheet as they are in the same order of my filtered template. However, when I paste the information it disregards the filter and pastes it on the sheet containing all the data. Naturally, the information is not pasted in the right cells. I have gotten around it by copying the filtered template into a new sheet however now i would like to populate my original template but I am encountering the same problem. I hope that this is clear. Thank you very much in advance, laurent -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Min values in a list of numbers | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Excel clipboard should allow pasting of formulae not just values | Excel Discussion (Misc queries) | |||
Second serie doesn't use X-as values | Charts and Charting in Excel |