Coding with ChatGPT: Write Your First VBA Code in Excel in 10 Minutes!

00:00 Introduction
00:48 VBA Code Video and File
02:26 Write Code in ChatGPT
07:33 Run Code with New Dataset

Related Links:

******More Videos in Playlists******

#ExcelforHR#HRAnalytics#Excel#HR

[pravinbhaichavada]

I have tried but now i want you to help me. I am looking for a VBA code to automate page break for a specific range which has hidden rows. page break should have equal rows in both page. and only if this range exceeds specific number of rows. waiting for your reply. I can also share excel file if you are ready to help

[tarakram]

How to tell chatgpt to perform vlookup from sheet 1 to sheet2
Ex lookup_value in sheet1 "A" column, table array G: AA in sheet2 i need corresponding value from AA.

I don't understand how to tell chatgpt, there is no videos how to ask chatgpt to do vlookup, conditional m if, else if etc, , , format
PLEASE CREATE SOME BASIC VIDEOS FOR CHATGPT FOR EXCEL

i have asked below steps but it's not giving correct out put.

create an excel macro for below requirement
1. ask the select input file to proceed to create macro and input file should be in macro enabled worksheet
2. after selected file go to sheet name as "CombinedStats" and if filter already applied at any row un filter it and select 2nd row apply filter for entire 2nd row.
3. after filter apply at E2 select only "0" from drop down list and copy the data from A2 and B2 and E2 to till last available data
4. create new excel sheet in same input file and then paste copied data in column "A". and rename newly created sheet as "DISC"
Do the number format for all columns in "DISC" sheet.
In input sheet there is a sheet "DORIS" Do the lookup as below
do the vlookup for "A" column values in "DISC" sheet from "DORIS" with the reference of "G" column in "DORIS" sheet and copy & paste the "AA" column detail of "DORIS" sheet and close