Pops when manually putting in the data what 2 summary sheets are you referring to update with the pdws?
for the popsummary only need to copy past special 5 col from the pdws to that summary col a, home team, col e day/night, col i vis team, col v ump and col z al or nl, you know which col give you that same data on the pdws
on the wa nps it a few more, col c series game number, col d home team, col e home pitcher, col l d/n, col p visiting team, col q visiting pitcher, col BE umps, col bl al/nl and the two most critical col BT gets the Visiting starting pitcher l/r, and col BV gets the home team l/r
i open both at the same time using horiz mode and it take about 2 min to do both sheets. make sure you do edit copy after your drag down of the entire col in the pdws and do a past special values in the 1st row of that col. if you dont it will remove the drop downs from those cols and prevent you from entering the data manually if you have a pitching our ump change