I set up a series of pivot tables to record class rosters for a few different classes. It worked very well for making the initial roster, but the problem I have is when I cut and paste from one roster to another (the data is cut and pasted from what one table is reading to another), the table that just gained a person works fine and the table that just lost a person won't update at all. In addition, the table that lost the person has its data location set to a single line from the worksheet, instead of the whole area.
Anybody have any ideas how to fix that?
Bookmarks