Look Up for multiple sheets?
I wonder if someone would be so kind as to help me with a little problem... I have 12 different workbooks, one for each store, for labour and sales forecasting. On each workbook there are a few different sheets - one for each period and then a final sheet which shows the total for each week and period, giving a quarterly summary. The only problem with this is when I want to review these I have to open individually 12 different workbooks. Is there a way that I can create a new workbook, which shows the 'Quarterly Summary' page for each store. I initially thought a look up formula, but I think this only applies to particular cells and not an entire sheets? Thanks in advance!
Autopopulate formula across worksheets?
I am trying to create a lunch schedule for the year with approx 30 people. Each day a new person will be chosen (with their initials on Picture 1), and then it will automatically rotate (sheet 1). Sheet 2 will have their name, the date of their scheduled lunch, and what they are bringing. How do I autopopulate the date from sheet 1 to sheet 2? Also it's not exactly perfect, because people get sick or are away, and then I have to substitute someone else who is coming that day to do lunch, and I want the date to autopopulate as well on Sheet 2 when I have to make a change on Sheet 1. Hope what I'm asking for makes sense. How do I do this?
Utilizing Excel's turing capabilities to create Conway's 'Game of Life'
The Background It's been said with Lambda (and LET and a wealth of functions in 365) Excel has become 'turing-complete'. To quote the article linked below: "You can now, in principle, write any computation in the Excel formula language." https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/ The Challenge I thought it would be fun to create Conway's 'Game of Life' in Excel 365 to see how far I could push things. Conway's Game of Life - Wikipedia The rules are simple: A 'cell' has up to 8 adjacent cells (less if the cell is on the edge of the board). A 'neighbor' is a cell with a 1 while a 'dead' cell is empty. An 18x18 board Multiple iterations Bigger boards! more (it's relaxing to create new shapes and designs) The Approach My first thought was to use MAKEARRAY because I could use 'r' and 'c' coordinates and there would be no stacking. I devised a recursive function that worked for 1 iteration but failed on subsequent iterations because the use of TAKE/DROP was slowly shrinking the board! The revised approach is essentialy a recursive MAP that uses 3 arrays: the input matrix, the 'r' array (row numbers) and the 'c' array (column numbers). It's my way of using r/c without using MAKEARRAY. For Discussion I welcome any improvements to the existing function and any different approaches someone may have to creating Conway's Game of Life. Conway Lambda follows: Conway =LAMBDA(matrix, iterations, IF( iterations = 0, matrix, Conway( LET( height, ROWS(matrix), width, COLUMNS(matrix), r_arr, SEQUENCE(height) * SEQUENCE(, width, 1, 0), c_arr, SEQUENCE(height, , 1, 0) * SEQUENCE(, width), CheckNeighbors, LAMBDA(lattice, r, c, LET( RCx, LAMBDA(row, col, IFERROR(CHOOSECOLS(CHOOSEROWS(matrix, row), col), 0) ), N, RCx(r - 1, c), NE, RCx(r - 1, c + 1), E, RCx(r, c + 1), SE, RCx(r + 1, c + 1), S, RCx(r + 1, c), SW, RCx(r + 1, c - 1), W, RCx(r, c - 1), NW, RCx(r - 1, c - 1), compass, VSTACK(N, NE, E, SE, S, SW, W, NW), neighbors, SUM(compass), IF( AND(lattice = 0, neighbors = 3), 1, IF( AND(lattice = 1, OR(neighbors = 2, neighbors = 3)), 1, 0 ) ) ) ), MAP(matrix, r_arr, c_arr, CheckNeighbors) ), iterations - 1 ) ) )
Add Official Password Recovery Option for Protected Office Files
Halo Tim Microsoft, Saya Heru Arwadinata, seorang IT Manager, ingin mengusulkan fitur yang menurut saya akan sangat bermanfaat bagi banyak pengguna Microsoft Office: Mekanisme resmi untuk pemulihan password dokumen Office (khususnya Excel dan Word). Saat ini, ketika pengguna lupa password, tidak ada cara bawaan dari Microsoft untuk memulihkan dokumen tersebut — yang tersedia hanyalah alat pihak ketiga yang: Berbayar Tidak selalu dapat diandalkan Berpotensi membahayakan keamanan data Sebagai perbandingan, ketika kita lupa password email, ada prosedur pemulihan yang jelas, aman, dan mudah (misalnya melalui nomor HP atau email pemulihan). Mengapa tidak menerapkan konsep serupa pada dokumen Office? Mengingat Office digunakan secara luas dalam lingkungan bisnis dan pemerintahan untuk menyimpan data penting, menurut saya Microsoft sebaiknya menyediakan solusi pemulihan yang aman dan terintegrasi, seperti: Verifikasi identitas atau bukti kepemilikan Proses pemulihan melalui akun Microsoft Opsi override oleh admin perusahaan (untuk pengguna enterprise) Hal ini akan sangat membantu mengurangi ketergantungan pada pihak ketiga dan meningkatkan kepercayaan pengguna terhadap Microsoft Office. Terima kasih atas perhatian dan pertimbangannya. Saya sangat menantikan tanggapan dari tim Microsoft maupun komunitas. Hormat saya, Heru Arwadinata ==================================================================== Hello Microsoft Team, I’m Heru Arwadinata, an IT Manager, and I’d like to propose a feature that could be a game-changer for many Office users: An official password recovery option for Microsoft Office documents (particularly Excel and Word). Currently, when a password is lost, users have no native way to recover their documents — relying instead on third-party tools that are often: Expensive Unreliable Potentially insecure As a comparison, when we forget a password for our email account, there’s a clear, safe, and guided recovery process (e.g., via phone or alternate email). Why not bring the same concept to Office documents? Considering Office is widely used for sensitive data in business and government environments, I believe Microsoft should provide a secure, built-in recovery solution, possibly based on: Proof of ownership Identity/account verification Or enterprise admin-level override (for corporate environments) This would significantly reduce reliance on risky third-party tools and boost user confidence. Thank you for your time and for considering this idea. I’d love to hear feedback from the community and Microsoft team. Best regards, Heru ArwadinataFilter via checkboxes with multiple criteria
I want to make a feature/application matrix where you can choose features by clicking on a checkbox and the filter needs to show only the application where all the chosen (checked) are available. So instead of the inbuild header filter I want to choose by checking / unchecking the boxes . Example: Can some one tell me how to achieve this? (I prefer to have the features vertically and the application/platform horizontally but I think that's harder to achieve or I'm I wrong?)
VBA Coding to hide/unhide a row based on a cells colour
Hi, I'm fairly new to VBA and just getting to grips with some basic functions but am struggling with a slightly more complex one that i would like to implement. I have searched around but can't find an answer to my specific problem so hoping someone here will be able to point me in the right direction please. I have an excel workbook with multiple sheets. Lets call them Sheet1 and Sheet2. I currently have a conditional format set so that if cellA1 in Sheet2 is Red, then cellA2 in Sheet1 auto formats to red and any text in cellB1 in Sheet2 is brought forward to cellB2 in Sheet1 (via in cell formula, not VBA) with row2 of sheet1 in standard position of hidden. I would like to add a string into VBA so that when cell A2 of sheet1 auto formats to Red, row2 sheet1 unhides, but any other value/colour present would keep row2 hidden. A few questions around this: Is this even possible? Do i need to move the colour formatting into VBA instead of an in cell formula and conditional formatting, and if yes, how do i do that? So far my VBA experience is mostly just straightforward 'IF' functions and my knowledge is very basic so i would be very grateful of any advice and suggestions you have with clear descriptions so i can understand and learn. Thank you in advance :)
Filter list based on another cell
Creating a project timesheet where employees input their hours each week for each project so we can appropriately charge the client. I need it to function so when the employee selects their name in the validation drop down list it automatically filters out everyone else's project hours for that week. E.g. They would select their initials in cell C2 and it would automatically hide all the rows and only show the corresponding rows for the selected employee. So for employee "FC" it would go from looking like this... To this... Alternatively, if there is a far easier way of doing this would love the advice. Thank you
