Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multiple workbooks
Hi Theresa,
Thank you for your quesiton.
You can use the Data Consolidation command if you want a summary workbook that summarises data from other workbooks or you can use the Copy command followed by Paste Special Paste Link.
I hope this answers your question.
Regards
Simon
You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
