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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.