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
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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