Kyle Johnson2;42635897 said:Are you certain? What happens when a user double-clicks on a different cell?
I am absolutely certain. Both Macros and the VBA editor are greyed out. 🤷
When I double-click, it just opens the cell for standard entry because nothing has been defined to trigger an action. This EXCELLENT option perfectly solves my problem, especially since I can't run anything without Macros or access the VBA enabled. 😠
I also want to take this opportunity to publicly THANK you—both personally and on behalf of ALL OF US who constantly pester you and envy your seemingly endless patience. ☕
Home ›
Gerald Barnes › Posts
Posts by Gerald Barnes
3 posts shown.
Kyle Johnson2 said:I have no idea why you’ve made this so complicated, but honestly, just go find some tutorials on copying in Excel. See if there's anything you can actually adapt to fix your mess.
- Copying via a double-click on a cell.
- Copying data using the Advanced Filter feature.
- Copying selected cells.
- Copying non-adjacent cells.
It’s most likely that "Double-click to copy" option. I'm having an issue where View Code is grayed out, which is preventing me from moving forward... I don't get it.
Does anyone know if this "magic" add-on can handle one specific scenario?
After spending an eternity inputting data and building out formulas, I’ve managed to resolve everything 🙂 except for one simple request—assuming it's even possible. My goal is to allow my colleagues to open a prepared workbook containing two sheets (where the first sheet holds item names and prices, etc.) and, with just a click, transfer only a specific item name and its price over to the second sheet rather than the entire dataset. I've been trying to find a workaround, but I can't seem to find a solution that doesn't involve overly complex formulas that would be far too difficult for them to manage🙂... I would appreciate any advice. Thanks in advance!
After spending an eternity inputting data and building out formulas, I’ve managed to resolve everything 🙂 except for one simple request—assuming it's even possible. My goal is to allow my colleagues to open a prepared workbook containing two sheets (where the first sheet holds item names and prices, etc.) and, with just a click, transfer only a specific item name and its price over to the second sheet rather than the entire dataset. I've been trying to find a workaround, but I can't seem to find a solution that doesn't involve overly complex formulas that would be far too difficult for them to manage🙂... I would appreciate any advice. Thanks in advance!