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
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.
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
Merging sheets in the same spreadsheet