problem with paste special

taichee

New Member
Joined
Oct 13, 2002
Messages
6
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!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
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

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
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

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
Maybe what you need to use is the Advanced filter, which allows you to copy and paste to a new location directly.
 

taichee

New Member
Joined
Oct 13, 2002
Messages
6

ADVERTISEMENT

[No message]
 

taichee

New Member
Joined
Oct 13, 2002
Messages
6
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

New Member
Joined
Oct 13, 2002
Messages
6

ADVERTISEMENT

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

New Member
Joined
Oct 13, 2002
Messages
6
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

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
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.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
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
ABCDEFG
1Fruit
2Apples
3Oranges
4Bananas
5Grapes
6Lemons
7Apples
8Oranges
9Bananas
10Grapes
11Lemons
12Apples
13Oranges
14
15
16Apples
17Grapes
18Apples
19Grapes
20Apples
21
Sheet1
 

Forum statistics

Threads
1,144,736
Messages
5,725,994
Members
422,652
Latest member
Elnene1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top