In a spreadsheet I am working on, the master data is contained in a
spreadsheet with data reported in rows. A client has asked us for various
reports, but wants the data reported in columns. In order to create a link
to the master spreadsheet, I used a mixed reference, to have the absolute
row, but a relative column. However, when I try to copy this formula
forward, it only copies the same mixed address, rather than advancing the
column as I thought it would.