Forum Discussion
Connecting Two Data Sheets
If you're primarily using Excel Online, you can achieve your goal by utilizing Excel Online's collaboration features. Here's how you can collaborate and link data between Excel Online spreadsheets:
- Share Both Spreadsheets:
- Make sure both your event planning sheet and attendance tracking sheet are saved in a location accessible to all team members, such as OneDrive or SharePoint.
- Collaborative Editing:
- Share both spreadsheets with your team members.
- Multiple users can collaborate on the same sheet simultaneously.
- Connect Data between Sheets:
- In your attendance tracking sheet, use a formula to link data from the event planning sheet. For example, you can use VLOOKUP, INDEX-MATCH, or simple cell references.
Example VLOOKUP formula for linking data from the event planning sheet:
=VLOOKUP([Common Identifier], [Event Planning Sheet Range], [Column Number], FALSE)
Formula is untested.
Replace [Common Identifier] with the cell containing the identifier you're matching on, [Event Planning Sheet Range] with the range in the event planning sheet that contains the data you need, and [Column Number] with the column number that contains the data you want to pull.
- Real-Time Collaboration:
- As your team members make updates in the event planning sheet, the linked data in the attendance tracking sheet will automatically update in real-time.
By using Excel Online and collaborative editing, you can maintain data consistency and real-time updates between your event planning and attendance tracking sheets, even if rows are added or modified. This approach doesn't require Power Query or Power Pivot and can work effectively for smaller teams or simpler data tracking scenarios. The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.