Great!
Works a treat. Thanks Debra.

"Debra Dalgleish" wrote:

You can use the Worksheet_Change event on Sheet1, e.g.:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 Then
Sheets("Sheet2").PivotTables(1).PivotCache.Refresh
End If
End Sub


ShaneS wrote:
Thanks Debra.
I have this code on sheet2 already and it is very useful. But I still need
to be able to refresh when entering text into a column from another
worksheet, as this sheet shows a reference from the pivot table. As it is, I
need to refresh sheet2, and then go back to sheet1. Is it possible to refresh
from a particular column entry in sheet1?

Thanks.
Shane.

"Debra Dalgleish" wrote:


You could refresh the pivot table when Sheet2 is activated.

Right-click on the Sheet2 tab, choose View Code, and paste the following
code where the cursor is flashing:

Private Sub Worksheet_Activate()
PivotTables(1).PivotCache.Refresh
End Sub


ShaneS wrote:

Hello
I am needing to write a code so that if I was to enter a value into a
particular column (say A:A) on one worksheet (named Sheet1), the PivotTable1
on another worksheet (named Sheet2) will refresh. I'm sure this will be easy
for someone out there!

Thanks in advance!

Shane.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html