I tried ChatGPT but there are significant steps missing. I am VERY new to this and my company’s IT department cannot assist me since its not a company application. In ChatGPT it says use VBA but I am unfamiliar with the language as I’m a biologist by profession with slightly above basic excel knowledge. PLEASE HELP.

I tried using the VBA option in excel. I do no understand what I am supposed to be filling out. I watched YouTube videos and read articles. Again I have tried ChatGPT. I’m not understanding. Here is what they gave me on ChatGPT:

1. Create a Macro: Write a VBA macro that triggers when a new item is added to the spreadsheet. This macro should include the code to send an email. You can use the Workbook_SheetChange event to trigger the macro when a change occurs in the worksheet.

*****“`vba
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
‘ Define your conditions for triggering the email
If Target.Column = [Column Number] And Target.Row > [Starting Row] Then
‘ Call the function to send email
SendEmail
End If
End Sub

Sub SendEmail()
‘ Add your code to send email here
‘ This could involve creating an instance of Outlook and sending an email
End Sub***

Replace `[Column Number]` and `[Starting Row]` with the appropriate column and row numbers where new items are added.

2. **Configure Outlook**: If you're using Outlook to send emails, make sure Outlook is configured properly on your system.

3. **Enable Macros**: In Excel, go to `File` > `Options` > `Trust Center` > `Trust Center Settings` > `Macro Settings`, and select "Enable all macros" or "Enable macros for this session" depending on your security requirements.

4. **Testing**: Test the macro to ensure it works as expected. You can manually trigger it by adding a new item to the specified column and row.

5. **Error Handling**: Add error handling to your VBA code to handle any issues that might arise during the email sending process.

6. **Security**: Keep in mind that enabling macros can pose security risks. Ensure that you understand the implications and only enable macros from trusted sources.

Remember to save your Excel workbook as a macro-enabled workbook (.xlsm) to retain the VBA code.



I understand none of this.