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
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/MSLEcustomerpulseReminder - 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/MSLEcustomerpulseWEBINAR: Agentic AI in the Modern Lab: Transforming R&D productivity with Copilot for Researcher
🌟Register here (LinkedIn) and invite your customers for our upcoming webinar: Agentic AI in the Modern Lab: Transforming R&D productivity with Copilot for Researcher 🔬Series Overview The Microsoft Academic Research Exchange is a monthly global webinar series designed to foster open dialogue and knowledge sharing across the academic research community. Each session highlights real-world research applications, interdisciplinary collaboration, and emerging methodologies—creating space for researchers, institutions, and partners to exchange insights, explore challenges, and accelerate discovery together. 🌏Webinar Title: Agentic AI in the Modern Lab: Transforming R&D productivity with Copilot for Researcher 🔬Webinar Overview Discover how agentic AI is reshaping the way researchers work in life sciences. We’ll show how AI agents can connect to trusted databases like PubMed and bioRxiv, act as intelligent copilots to streamline literature search, and even assist with rewriting grants or publications. Don’t miss a live demo of Copilot for Researcher, developed by Witivio - AI Solutions for Microsoft Teams, showcasing how this next-generation research assistant reduces friction, boosts productivity, and empowers scientists to focus on discovery. 👨🔬👩⚕️Speakers: Nadège Poncet, PhD, AI Consultant for Life Science R&D, Witivio Nicolas Humann, Agentic AI Specialist, Witivio Date: Tuesday, October 28th 2025, 8:00 – 9:00 am PT (NOTE: Recording of session will be sent to all who register) Delivery Language: English Agenda: 8:00-8:05 AM PT Introduction of Series and Speakers 8:05-8:50 AM PT Witivio Copilot for Researcher overview and demo 8:50-9:00 AM PT Q&A LinkedIn Post 🌟Join the Microsoft Azure for Academic Research community (LinkedIn Login, Sign in | LinkedIn) on LinkedIn to follow this exciting series where we will post announcements about monthly webinars on cutting edge research focused topics!MSLE is offering FREE virtual AI Bootcamps! Space is limited.
Don't miss out on the opportunity to level up your AI skills - for FREE! Microsoft is offering free virtual AI Bootcamps for faculty through the MSLE program! AI is rapidly transforming the workforce, and educators play a vital role in preparing students for this shift. By attending a bootcamp, you'll not only gain hands-on experience with AI tools like Copilot but also learn how to embed essential AI and cybersecurity skills into your teaching—ensuring your students graduate career-ready in the age of AI. These are being offered for a limited time in multiple time zones and languages, from September 15 thru September 30, 2025. Choose from three tailored sessions: Generative AI – Use tools like Copilot in your daily work Technical Foundational AI – Teach core technical AI and machine learning skills Cybersecurity – Embed security principles into your courses Why Attend? Stay current with critical AI and cybersecurity skills Learn how to integrate these technologies into your teaching Help your students become workforce-ready in the AI era Receive a free Microsoft Fundamentals exam voucher upon completion of Technical Foundational or Cybersecurity Bootcamp Bootcamps are virtual, flexible, and offered in global time zones with sessions available in English, French, Spanish, Arabic, and Portuguese—choose the one that fits your goals. Go to the Events tab to register or visit https://aka.ms/FreeMSLEAIBootcamps
