creating a separate tab for a common table
My question from a few days ago disappeared and I cannot locate it. I have created an Excel financial spreadsheet for myself that amasses all monthly data from my checking, investments, and credit cards. There are about 20 tabs including each month, each major account and others. Each monthly and account spreadsheets are identical. I created a table that has 3 column of data: Payee, account, and category which, in theory, auto update each spreadsheet. The downside to what I currently have is that every sheet needs an updated table which doesn't always work out to be complete. What I'd prefer is to have a separate tab in the spreadsheet that every tab could reference. I saw this once and know it can be done but, of course, I cannot find it. So, the question is, how can I get each month to find the separate tab (call it Ref or anything else) and input the appropriate data into the sheets? The current formula I am using for assigning the info is: =XLOOKUP(H14,Q:Q,S:S). The column reference are currently being used are because that's where they fit on each monthly spreadsheet. The data example is in the last row of the spreadsheet. All help is appreciated. Steve Backman
📣 MSLE Onboarding Session​ — Português
Olá, đź‘‹ Espero que estejam bem! ✨Participe da sessĂŁo de introdução ao programa MSLE para Educadores! Nesta sessĂŁo: âś… Vamos explorar os benefĂcios e o alcance do programa âś… Conhecer em detalhe os dois portais principais aos quais vocĂŞ terá acesso âś… Esclarecer todas as suas dĂşvidas em um ambiente colaborativo Este Ă© o seu primeiro passo rumo a uma experiĂŞncia enriquecedora, onde conhecimento, inovação e comunidade se unem para impulsionar vocĂŞ ao prĂłximo nĂvel. No horário indicado, favor realizar acesso ao link: Teams meeting.đź“Ł MSLE Office Hours​ — French
Bonjour, 👋 J’espère que vous allez bien ! 📢 Vous souhaitez explorer l’IA et Microsoft Copilot de manière pratique pour l’apprentissage ? Participez à la session « Introduction à l’IA avec l’utilisation de MS Copilot », conçue spécialement pour les enseignants qui commencent à utiliser Copilot. Nous apprendrons les bases de l’IA générative, comment créer de bonnes instructions et comment appliquer ces outils en classe. 📌 Une session avec des exemples pratiques, des supports à utiliser et un espace idéal pour s’exercer et poser vos questions. À l’heure indiquée, veuillez accéder au lien : Réunion Teams. Merci !📣 MSLE Onboarding Session​ — French
Bonjour, 👋 J’espère que vous allez bien ! ✨ Participez à la session d’introduction au programme MSLE pour les enseignants ! Lors de cette session : ✅ Nous explorerons les avantages et la portée du programme ✅ Nous découvrirons en détail les deux portails principaux auxquels vous aurez accès ✅ Nous répondrons à toutes vos questions dans un environnement collaboratif C’est votre premier pas vers une expérience enrichissante, où savoir, innovation et communauté s’unissent pour vous propulser au niveau supérieur. À l’heure indiquée, veuillez accéder au lien : Réunion Teams. Merci !📣 Getting Started with AI and MS Copilot​​ — Português
Olá, 👋 Espero que estejam bem! 📢 Quer explorar IA e Microsoft Copilot de forma prática para o aprendizado? Participe da sessão “Introdução à IA com o uso do MS Copilot”, pensada especialmente para docentes que estão começando a usar o Copilot. Vamos aprender os fundamentos da IA generativa, como criar boas instruções e aplicar essas ferramentas na sala de aula. 📌 Sessão com exemplos práticos, materiais para utilizar e um espaço ideal para praticar e tirar dúvidas. No horário indicado, favor realizar acesso ao link: Teams meeting.Time is Running Out – Complete the MSLE Pulse Survey Today!
We’re counting on your feedback to help shape future MSLE initiatives and ensure we meet your needs. The MSLE Pulse Survey closes October 31st, so don’t miss your chance to share your thoughts! 👉 https://aka.ms/MSLEcustomerpulse Thank you for helping us make MSLE even better!Upcoming event for your students - Fabric Data Days
Hi educators! It's my pleasure to let you know that we have an upcoming event that your students may be interested in. Fabric Data Days is designed to empower students, recent graduates, educators, and early career professionals to build in-demand Data & AI skills, connect with the global Fabric Community, and earn industry-recognized certifications. Give your learners the tools to thrive in today's Data & AI landscape: ✅ Student-specific DataViz Challenge ✅ Career insights from industry experts ✅ Discounted certifications to boost their resumes Join the movement and help your students get engaged, skilled, and certified! 👉 https://aka.ms/fabricdatadays/nextgen Have questions? Ask in the thread here or send me a private message! p.s. there's no license of any kind required to participate!Reminder to complete the MSLE Pulse Survey
Just a friendly reminder to complete the MLSE Pulse survey if you haven't yet done so. Your feedback will help shape future initiatives and ensure we’re aligned with your needs. The survey will remain open until October 31st, so please take a few minutes to share your thoughts. Thank you for helping us make MSLE even better! Link to Survey: aka.ms/MSLEcustomerpulse
The MSLE Pulse Survey is now open!
We’d love your input! The MSLE Pulse Survey is now open and we’re inviting all members of the MSLE Community to participate. Your feedback will help shape future initiatives and ensure we’re aligned with your needs. The survey will remain open until October 31st, so please take a few minutes to share your thoughts. Thank you for helping us make MSLE even better! Link to Survey: aka.ms/MSLEcustomerpulse
