# Subtotal Question

#### ptdreamer

##### New Member
After I subtotal, in a worksheet and it gathers all the information and displays it to the bottom of the sheet.

The question is ......

How can I display just the subtotal information in another worksheet without pulling all of my cells over. I just want the final results of the subtotal. I don't the information from the collapse cells.

Any ideas or results..

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
in the cells in Sheet 2 try usingthe formula =Sheet1!A10 or whatever the subtotal cell total is.

When that happens it replies as #value.....

It does not pull the vaule over.

I gues what I am trying to say is...

If I have a value in H16, and I pull the information
I just want to drag the cell and pull the next celll would be H123,
so on and so forth.....Where it may skip groupings but still give the total amounts.

Not sure if this what you're after (it will not be linke)after but.
1. Display the table as you wish it to appear on the other sheet
2. Highlight it
3. Hit control G, Special, visable cells only, okay.
4. control C to copy
5. control v to paste in new sheet

If I understand you correctly, maybe try this ..

1) Press Ctrl + F3
2) Name = LastRow
3) Refers To: =MATCH(9.9999999E+307,Dest!\$C:\$C)
4) In your Summary sheet, formula: =INDEX(Dest!\$A:\$I,LastRow,COLUMN())

Note: My sheet with data is called "Dest", change to whatever you have. The formula will need to be in the same columns as the values in your Subtotal sheet. As you can see, mine were in A:H. In step 3, the column C was chosen at random. That would be the column that you know would be the largest (with the highest row number).

HTH

OK IML I tried but it pulled it over as a bitmap or picture and I......Is this right?

On my machine, it would just populate the new cells with those values.

Replies
40
Views
2K
Replies
4
Views
222
Replies
11
Views
500
Replies
1
Views
214
Replies
0
Views
551

1,220,986
Messages
6,157,224
Members
451,406
Latest member
Kevin_267

### 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.

### Which adblocker are you using?

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

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