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

[frade]

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]

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]

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]

Do you have any ideas?

Tank you by advance

Fran?ois

[Norie]

Why have you formatted the ref_status values as text on the Intro sheet?

[frade]

Thank you Norie,

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