copy level 2 data in an outline


R

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
 
Ad

Advertisements

G

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
 
G

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
 
R

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
 
D

Dave Peterson

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

Now copy and paste.
 
G

Guest

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

t

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

Edit|goto|special|visible cells only
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top