copy level 2 data in an outline

[randy]

How can I cleanly copy/paste five contiguous columns (B2-
F431) of just subtotaled data; I want just the level 2
detail in this range?

The worksheet dimensions are A1-N432, with 134 subtotaled
rows. All rows are subject to one outline with 3 levels
of grouping: 1=grand total, 2=subtotal, 3=all detail. The
summary description under grand total and subtotal rows
includes as its last word " ... 'Total'" in column B.

Thanks for your help!
Randy

 

[Guest]

What version of Excel are you using? In XP and 2003 (I don't have 2000 to try it on), you can do the following (simple if clunky) option
View Level 2 of the outline
Select the first column of data
Hold down Ctrl and select the each column individually

-OR

Since you have a a few hundred rows of data, you can select it like this
in the name box type the range for each column you want to select separated by a comma. For example, if you want to select
B1:B431 and E1:E431 and H1:H431 and K1:K431 and N1:N43
then type this into the name box
B1:B431,E1:E431,H1:H431,K1:K431,N1:N43

When all the cells are selected, you can copy and paste normally

t
----- randy wrote: ----

How can I cleanly copy/paste five contiguous columns (B2
F431) of just subtotaled data; I want just the level 2
detail in this range

The worksheet dimensions are A1-N432, with 134 subtotaled
rows. All rows are subject to one outline with 3 levels
of grouping: 1=grand total, 2=subtotal, 3=all detail. The
summary description under grand total and subtotal rows
includes as its last word " ... 'Total'" in column B

Thanks for your help
Rand

 

[Guest]

I should've mentioned that the discontiguous ranges have to be symmetrical
Copying and pasting A1:A5,E1:E5 is possible
Copying and pasting A1:A5,E1:E10 is not possible

tj

 

[randy]

I'm using Excel 2000 (9.0.7616 SP-3).

Thanks, but these methods pick-up the level 3 data as
well. Any other suggestions?

Randy

-----Original Message-----
What version of Excel are you using? In XP and 2003 (I

don't have 2000 to try it on), you can do the following
(simple if clunky) option:

View Level 2 of the outline.
Select the first column of data.
Hold down Ctrl and select the each column individually.

-OR-

Since you have a a few hundred rows of data, you can select it like this:
in the name box type the range for each column you want

to select separated by a comma. For example, if you want
to select

 

[Dave Peterson]

Show the level you want.
Select that range
Edit|goto|special|visible cells only

Now copy and paste.

 

[Guest]

Thanks, Dave. Somehow I always forget about the GoTo Special Options

t

----- Dave Peterson wrote: ----

Edit|goto|special|visible cells only

 

[Dave Peterson]

There's lots of neat stuff hidden under that Special button.

 

[Peo Sjoblom]

Try F5

 

[Dave Peterson]

Or ctrl-G.

Try F5

--

Regards,

Peo Sjoblom