I have a spreadsheet with multiple tabs that display the attendee list of some events. Each tab is titled using the date of the event, and the columns are First Name, Last Name, Company, Title, Address, City, State, Zip, Country, Phone, Mobile, Email, etc. Each tab has been formatted in exactly the same way, the only thing that is different is the content. Each tab has been loaded into my load script so there is an attendee list for each event date in QVW. I would like to add a new column for "Active Status" in my excel, but I would only like to add this once, rather than go back to each tab and mark each name entry as active or inactive. I tried adding a new tab with Email and Active Status as my columns, hoping that the Active status would apply only once to each name (with Email being a key that is unique to each attendee). However, when I loaded my QVW and viewed my data in a table, I had duplicate name entries and I don't know why.
