Pivot Table newbie here......I have a workbook that has the sheets labeled by
6 countrys so i do not have the country label within the sheet. Will the
current sheet be part of the field list to set it up or will i have to
include a new column called country? Also, is it possible to do one pivot
table with the fields from all sheets at one time for consolidated results?