View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fdibbins fdibbins is offline
external usenet poster
 
Posts: 8
Default use field data from 1 pivot table in another?

I have multiple pivot tables on 1 Excel worksheet, looking at different data
in different ways. But in each pivot table, the Page Field name (eg machine
mane) stays the same. Is there a way to automate entry of 1 field entry into
all of the tables? My VB knowledge is minimal