I don't even think this is possible, but I have been keeping data on a
spreadsheet that I need to place onto another spreadsheet. Is there a way to
format the columns so that a value placed in A3, A4, etc would automatically
populate a preset cell on another worksheet? The other worksheet is sent out
to clients, and needed to be formatted differently than the spreadsheet.