SaraWitch
Active Member
- Joined
- Sep 29, 2015
- Messages
- 322
- Office Version
- 365
- Platform
- Windows
Hello peeps.
Is there a formula where I can copy/consolidate text from multiple sheets to a summary sheet? I have a formula that can copy from one other sheet (='Sheet1'!$A1), but can't work out how to do more than one sheet (I've tried ='Sheet1'!$A1, 'Sheet2'!$A1, etc., but it doesn't work).
Any suggestions would be gratefully received!
Sara
Is there a formula where I can copy/consolidate text from multiple sheets to a summary sheet? I have a formula that can copy from one other sheet (='Sheet1'!$A1), but can't work out how to do more than one sheet (I've tried ='Sheet1'!$A1, 'Sheet2'!$A1, etc., but it doesn't work).
Any suggestions would be gratefully received!
Sara