PDA

View Full Version : Sleeper: How to add a formula on one row directly below a pivot table?



frade
09-19-2005, 01:02 AM
Hello,

I have a last question about the position of the stdev values
on the sheet "TP_Repeat" . For your information, the code is launched
after a click on a button (see sheet "summary")

The values are correct but there are placed on two different rows. (Row 14 and 27 in my example..I have to put the results only on row 14..from B to M)

Xld, in the previous example, it was OK

What could I change?

Thanks a lot for your advice

Fran?ois

Bob Phillips
09-19-2005, 01:51 AM
You are referring to a range within a range, effectively offsetting an offset

Change



With .Range("B" & iLastRow)
.Copy .Range("B" & iLastRow).Resize(1, iLastColumn - 1)
.Resize(1, iLastColumn - 1).Value = _
.Resize(1, iLastColumn - 1).Value
End With


to



With .Range("B" & iLastRow)
.Copy .Resize(1, iLastColumn - 1)
.Resize(1, iLastColumn - 1).Value = _
.Resize(1, iLastColumn - 1).Value
End With

frade
09-19-2005, 06:00 AM
Thank you..the problem is solved but if you have time to look at the new file

You will see the illogical order of the columns on the pivot table

0, 1024, 128

I understand well a little bit...the ascending values of the corresponding
ascii code but in my case..it's not interesting..

It would be better to see 0,2,4,8..or just consider the order of entered values
Intro!E2 then Intro!E3 then Intro!E4.

What could I change in the code?

Regards

Fran?ois

frade
09-19-2005, 09:17 AM
Do you have any ideas?

Tank you by advance

Fran?ois

Norie
09-19-2005, 10:22 AM
Why have you formatted the ref_status values as text on the Intro sheet?

frade
09-19-2005, 02:42 PM
Thank you Norie,:hi:

I have formatted the ref_status values as text on the Intro sheet

for the following reasons:

In this column, you can have 0,2,4,8 but also
0, 1/2,1/4,1/8 and I have to keep this symbol '/'
Other possibilites are "NEG", "POS" and so on..

I don't know how to keep the order of entered values
as the order of the columns in the pivot table.
With number as format, 1/4 by example is directly transformed
in 0,25 (decimal places equal to 2) ..It's the same indeed but
I would to keep the original informations..

Regards,

Fran?ois