I am consolidating 2 ranges per sheet and about 34 sheets. Having to go in
and manually type in the page field for each range is very cumbersome and
time consuming. Question 1 is there a way to assign Page Field Names besides
typing them in manually. Question 2 is it possible to make the page field be
the sheet name?