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.