Merging sheets in the same spreadsheet
How might I consolidate information from several sheets of the same spreadsheet into one sheet in that spreadsheet?
MacBook Air 13″, macOS 13.2
How might I consolidate information from several sheets of the same spreadsheet into one sheet in that spreadsheet?
MacBook Air 13″, macOS 13.2
What kind of "information"?
Often you can just select the object, command-c to copy, go to the place in the document where you want it, and command-v to paste.
SG
What kind of "information"?
Often you can just select the object, command-c to copy, go to the place in the document where you want it, and command-v to paste.
SG
Remembered a friend who uses Numbers extensively. Procedure was simple: = in the cell needing filling; curser to sheet and cell with information in one or multiple sheets (Sum automatically adds new locations); click return or check green arrow. Simple.
Merging sheets in the same spreadsheet