Formula Copy Row 2 Row But Next Column In Formula From Another Tab
I have a formula in a spreadsheet that references a cell from another tab. When I copy that formula to the next row of my spreadsheet, I want the new formula to reference the value from the cell in the next column of the spreadsheet in that other tab, not from the cell in the next row of the spreadsheet in that other tab. Can I do that and how?
|