on report1 worksheet have series of sums from m2120 out 150 columns and I
want to take these sums and transpose them to report2. (so they run
vertically on report2 down column 2)
by using ='report1'm2120, then ...n2120...o2120 and so forth, but i am
getting m2121, m2122, m2123 and so forth when trying to use autofill
any ideas, thx