Hi everyone, sorry if the subject is confusing.
I have a workbook with 100 sheets that feed data to a ledger sheet. The ledger is by necessity in a column format, and I want to reference B6 on the other 100 sheets. When I put in ='2'!B$6 and copy/paste I wind up with the entire column referencing sheet 2. How do I get it to reference 3, 4, etc?
Bookmarks