ChatGPT REVOLUTIONIZES Excel: Automate your work in seconds (no VBA knowledge required) 👨💻
► Subscribe to the channel: https://bit.ly/lobilution
► Link to OpenAI (You'll find the macro at the end of the video description):
ChatGPT: https://chat.openai.com
In this video tutorial, I'll show you everything you can do with ChatGPT from OpenAI. #chatgpt is (currently) a free chatbot based on artificial intelligence (AI). It can provide answers in many areas of your life. In my video, I'll show you how to create your own formulas in #Excel using ChatGPT, or even have entire #macros / Excel #vba code written without you needing any programming knowledge. I'm very curious to see how you use ChatGPT and whether you like it. I hope I've explained ChatGPT clearly.
Artificial intelligence has made great strides in recent years. Thanks to OpenAI and chatGPT, there's finally a way to significantly simplify your work with the help of AI. The software now understands very precisely what you want it to do and learns more every day. Therefore, you might receive different answers to the same question repeatedly. However, most of the answers are very accurate.
▬ My Equipment ▬▬▬▬▬▬▬▬▬▬▬▬▬
In the video:
► *Microphone: https://amzn.to/3CX3XyP
► *Software: https://amzn.to/3ZIAUZE
► *Video Editing Software: https://amzn.to/3iGP2SF
*Thank you for your free support through these affiliate links!
In the video:
► *Microphone: https://amzn.to/3CX3XyP
► *Software: https://amzn.to/3ZIAUZE
► *Video Editing Software: https://amzn.to/3iGP2SF
*Thank you for your free support through these affiliate links!
► *Microphone: https://amzn.to/3CX3XyP
► *Software: https://amzn.to/3iGP2SF
*Thank you for your support through these affiliate links! ▬ More Videos ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► Pivot Tables Explained Simply:
• Excel: Pivot Tabelle erstellen - Schritt f...
► Creating a Drop-Down List with Changing Colors:
• Excel: DropDown Liste erstellen mit wechse...
► Excel: Checkboxes:
• Excel: Kontrollkästchen / Checkboxen einfü...
▬ The #ExcelMacro Created in the Video ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Sub SaveAsPDF()
'Variable declarations
Dim ws As Worksheet
Dim rangeToSave As Range
Dim pdfName As String
Dim pdfPath As String
'Set worksheet variables
Set ws = ThisWorkbook.Sheets("Sheet1")
'Set range variable
Set rangeToSave = ws.Range("B3:D17")
'Set pdf name variable
pdfName = ws.Range("C19").Value
'Set pdf path variable
pdfPath = ws.Range("C20").Value
'Save range as PDF
rangeToSave.ExportAsFixedFormat_
Type:=xlTypePDF, _
Filename:=pdfPath & pdfName, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, -
OpenAfterPublish:=False
End Sub
▬My Channel▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► Subscribe to my channel: https://www.youtube.com/c/Lobilution?...