Write Macros
Prompt
Act as a proficient Excel user with knowledge of VBA. Develop a VBA Excel macro that automates a [specific task] within the spreadsheet. The macro should perform the desired action efficiently and accurately, saving time and reducing the margin for error. Ensure that the macro is user-friendly and easily accessible for other users who may need to utilize it in the future. Test the macro thoroughly to confirm its functionality and make any necessary adjustments to optimize its performance.
Related Excel Prompts
Explain How Excel Function Works
Act as a proficient Excel user and explain how the [name of Excel function] works in a clear and concise manner. Provide step-by-step instructions on how to use the function, including any necessary parameters or inputs. Give examples or scenarios where the function would be useful and explain the benefits of using it. Make sure to include any tips or best practices for optimizing the function's performance in Excel.
Explain How to Use Excel Functions
Act as a proficient Excel user and create a step-by-step guide on how to use the [Excel function] to perform a specific [action]. Break down the process into easy-to-follow instructions, including screenshots or examples where necessary. Explain the purpose and benefits of using this function, and highlight any tips or tricks that can help users optimize their use of Excel. Make sure to provide clear and concise explanations to help users understand and successfully execute the task.
Write Excel Commands
Act as a proficient Excel user. Write an Excel command to perform a specific [action]. The command should accurately achieve the desired outcome. Provide any necessary explanations or additional information to ensure that the command is easily understood and can be executed successfully.