Master
over the tag line Sheet1.Master
. In cells A3 through F3 type these column headers: Sales ID
, Sales Person
, Address
, City
, State
, Zip Code
.101
through 110
. The Sales ID is the unique data value that’s used to create a relationship between your two tables.Master
.Sales
over the tag line Sheet2.Total Sales for 2013
. In cells A3 through E3, type Sales ID
, Quarter1
, Quarter2
, Quarter3
, and Quarter4
.101
through 110
.Sales
.