One Keyboard, One Mouse — Control Every Machine Seamlessly

🖥️

One Keyboard, One Mouse — Control Every Machine Seamlessly

Tired of switching between your Mac, Windows PC, and Linux boxes? Beamer lets you use a single keyboard and mouse across all your machines on the same network. Push your cursor off the edge of one screen and it flows right onto the next — just like a multi-monitor setup, but with real computers.

✨ What It Does

• 🖱️ Cross the edge — push your pointer through the screen border and it arrives on the other machine at the same position
• ⌨️ Keyboard follows you — type natively on any connected machine with smart key remapping (Cmd↔Ctrl, Option↔Alt)
• 📋 Clipboard travels — copy text and images on one machine and paste them on another instantly
• 🎯 Mac gestures on Windows — swipe your trackpad for Task View, desktop switching, and more
• 🔒 Your network only — no cloud servers, encrypted P2P connection, paired with a simple 6-digit code

⚡ Quick Setup

• 🍎 macOS: Download the .dmg, drag to Applications, grant permissions and relaunch
• 🪟 Windows: Run the installer — approve SmartScreen warning with "More info" → "Run anyway"
• 🐧 Linux (Flatpak):

flatpak install --user https://flatpak.kalkmancode.co.uk/beamer.flatpakref

💬 FAQ

Is Beamer free? Yes — completely free, open-source under GPL-3.0, no account required.

Can I connect more than two machines? Absolutely! Pair each machine with every other one for a chain of any size.

Does it work between two Macs or two PCs? Yes — Beamer works in any direction and between identical platforms too.

👉 Give it a try today — your workflow will thank you!

🔗 Check out Beamer on GitHub

📊 Excel 365: Extract Data Between Sheets Based on Criteria

lang:en

🚀 Filter and Transfer Data Between Excel Sheets with Ease

Excel 365 provides powerful functions to extract data from one sheet to another based on specific criteria, eliminating the need for manual copy-paste and saving precious time. Here are the key functions:

⚡ Main Functions

• 🔍 FILTER — select rows that match a specific criterion
• 📦 INDEX + MATCH — combine lookup and return of matching data
• 🧠 VLOOKUP — search for values in a table and return related data
• 🎯 XLOOKUP — modern and more flexible version of VLOOKUP
• 💻 DYNAMIC FILTER — create a live view of filtered data that auto-updates
• 📊 UNION — combine results from multiple ranges or sheets

🐍 How It Works

• 📦 Define the filter criterion (e.g., column = specific value)
• 🔗 Apply the formula =FILTER(table; criteria; "no data") to select rows
• ⚡ The result spills automatically into the destination sheet
• 🔄 Any change in the source data reflects in real time

🏆 Advantages

• 🚀 No copy-paste — data transfers automatically
• ⚡ Live update — change the criterion, change the result
• 🧠 No macros needed — only native Excel formulas
• 📊 Scalable — works with hundreds or thousands of rows

👉 Practical Example

To extract all "Sales" department data from the Data sheet to the Summary sheet:

=FILTER(Data!A2:E100; Data!B2:B100="Sales"; "No data found")

👉 Video tutorial: https://www.youtube.com/shorts/GTixn5IJAlM