macro to clear data below below

[howard]

I have a Pivot Table on sheet "Summary"

col A & B form part of the pivot Table & Col C contains formula's


I would like a macro to clear all data in Col C in the rows below where Grand total appears in Col A



Your assistance in this regard is most appreciated

 

[oldbrewer]

so check col A for grand total, if not found do nothing

when found do nothing but set Z1 to 1

now if z1=1 delete value in c

it is a very simple macro - can you write it ?

 

[oldbrewer]

values						orig data		values
3		7.7						3		7.7
4		7.9						4		7.9
5		8.1						5		8.1
grand total	12	8.3						grand total	12	8.3
										8.5
										8.7
										8.9
										9.1
										9.3
										9.5
										9.7
		this macro altered your table
		Sub Macro4()
		'
		' Macro4 Macro
		' Macro recorded 13/02/2018 by bob
		'
		'
		For j = 2 To 12
		50 If Cells(j, 1) = "grand total" Then Cells(1, 26) = 1: GoTo 100
		If Cells(1, 26) = 1 Then Cells(j, 3) = ""
		100 Next j
		Cells(1, 26) = ""
		End Sub

<colgroup><col><col span="13"></colgroup><tbody>
</tbody>

 

[howard]

Thanks for the help, much appreciated