problem with paste special

[taichee]

I have a *simple* database listing people and a large number of data in respect of each person.

I use auto filter in order to get the section of the list I need.
Then I use EDIT /PASTE SPECIAL to paste just that list into a new sheet.

I constantly get different rows and not the section I selected.

Can anyone give me a hint of what I am doing wrong?

Thanks!

 

[Mark W.]

On 2002-10-14 16:37, taichee wrote:
I have a *simple* database listing people and a large number of data in respect of each person.

I use auto filter in order to get the section of the list I need.
Then I use EDIT /PASTE SPECIAL to paste just that list into a new sheet.

I constantly get different rows and not the section I selected.

Can anyone give me a hint of what I am doing wrong?

Thanks!

What Paste Special option are you using?

 

[shades]

If you select and copy those rows by clicking on the row, the shift-clicking at the bottom row, when you paste, it will include all the rows in-between.

_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-10-14 17:07

 

[shades]

Maybe what you need to use is the Advanced filter, which allows you to copy and paste to a new location directly.

 

[taichee]

[No message]

 

[taichee]

On 2002-10-14 16:46, Mark W. wrote:

On 2002-10-14 16:37, taichee wrote:
I have a *simple* database listing people and a large number of data in respect of each person.

I use auto filter in order to get the section of the list I need.
Then I use EDIT /PASTE SPECIAL to paste just that list into a new sheet.

I constantly get different rows and not the section I selected.

Can anyone give me a hint of what I am doing wrong?

Thanks!

What Paste Special option are you using?

Paste - ALL
Operation - NONE
SKIP BLANKS
PASTE LINKS

after all this I get a slit that has nothing in common with the list I copied after FILTER

 

[taichee]

On 2002-10-14 17:06, shades wrote:
If you select and copy those rows by clicking on the row, the shift-clicking at the bottom row, when you paste, it will include all the rows in-between.

_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-10-14 17:07

yes but that will not give me a LINK from the original list to the new list!

 

[taichee]

On 2002-10-14 17:10, shades wrote:
Maybe what you need to use is the Advanced filter, which allows you to copy and paste to a new location directly.

the ADVANCED filter will not give me a LINK between the original and the new list

 

[shades]

On 2002-10-19 16:35, taichee wrote:
the ADVANCED filter will not give me a LINK between the original and the new list

Sorry, didn't realize that this was part of the original request.

 

[Mark W.]

On 2002-10-19 16:31, taichee wrote:

On 2002-10-14 16:46, Mark W. wrote:

On 2002-10-14 16:37, taichee wrote:
I have a *simple* database listing people and a large number of data in respect of each person.

I use auto filter in order to get the section of the list I need.
Then I use EDIT /PASTE SPECIAL to paste just that list into a new sheet.

I constantly get different rows and not the section I selected.

Can anyone give me a hint of what I am doing wrong?

Thanks!

What Paste Special option are you using?

Paste - ALL
Operation - NONE
SKIP BLANKS
PASTE LINKS

after all this I get a slit that has nothing in common with the list I copied after FILTER

I'm puzzled... How could you be using Skip Blanks and Paste Links? They're mutually exclusive. Also, I'm unable to reproduce your problem when I filter the following list for "Apples" or "Grapes" and Paste Special... Links directly below the original list...

Book1
	A	B	C	D	E	F	G
1	Fruit
2	Apples
3	Oranges
4	Bananas
5	Grapes
6	Lemons
7	Apples
8	Oranges
9	Bananas
10	Grapes
11	Lemons
12	Apples
13	Oranges
14
15
16	Apples
17	Grapes
18	Apples
19	Grapes
20	Apples
21
Sheet1