Also to be noted that I have bought the ChatGPT Pro, it is much faster and gives better answers, so if you are going to use ChatGPT quite a lot, it could be worth it to subscribe.
Great Video Leila,,, you never disappoint. Just a suggestion you may want to improve the quality of your audio. Not sure what course you should take, but you many consider a quality wireless microphone… Wish I could afford your consulting fees. Keep up the great work you are doing for all of us… GBY
I'm genuinely excited about how it can enhance my job and replace repetitive tasks, and I don't see it interfering with my career shortly. You'll need to ask the right question and ensure that the problems you give are very descriptive; otherwise, it is not at the value you hope it will. It has a lot of promise.
I CANT FIND THE ANSWER FOR MY PROBLEM. I NEED TO SUM THE COLUMNS OF ALL MY SHEETS IN A EXCEL FILE BUT ONLY IF THE THE MATCH CERTAIN CRITERIA IN ANOTHER SHEET. EXAMPLE SUM ALL PROFIT FROM ALL SHEETS BUT ONLY IF ITS JUNE
@help with Excel. In workbook: named D which has l2:m300 data validation list and vba code which help me to select multiple values in each cell and every value is separated by ;.
Problem/question I took the source from sheet Q, range C2:c60. My source for data validation changes. I want: whenever any value changes in c2:c60, it should also change the corresponding cells of l2:m300 cells.
It help me on my job for send queries to the corporative web database using the HTTP POST query method and so to retrieve the data from the production lines automatically, all with excel.
I asked ChatGPT to write a line of VBA code which gives me number of second filtered row, cause I couldn't find it on the Internet (you can find everywhere hints for first filtered row), and within a seconds Chat gave me that and it works.
Second row – > SecondVisibleRow = ActiveSheet.AutoFilter.Range.Offset(1).Resize(ActiveSheet.AutoFilter.Range.Rows.Count – 1).SpecialCells(xlCellTypeVisible)
Also to be noted that I have bought the ChatGPT Pro, it is much faster and gives better answers, so if you are going to use ChatGPT quite a lot, it could be worth it to subscribe.
We don't need chatgpt but we need your videos more
I integrated Siri with ChatGPT. Works well!
EXCEL SHEETS for STRENGTH & CONDITIONING COACHES. A very good video about this is available here ((Lukasz Lojas))…….
Alternatives to chatgpt with VSTACK function?
I am from india.if stock is received particular date then only enter that date .Other dates not entered how to get the formula
Chat LeilaPT
if we count number of spaces that will precisely tell us number of words
Is there a way chatgpt could help write a macro that would copy comments based on common PO numbers from a file for which I currently use VLOOKUP .
Great Video Leila,,, you never disappoint. Just a suggestion you may want to improve the quality of your audio. Not sure what course you should take, but you many consider a quality wireless microphone… Wish I could afford your consulting fees. Keep up the great work you are doing for all of us… GBY
Can CHATGPT be use to clean data or transform an unstructured data toa structure data set to avoid all the stress of data cleaning
I'm genuinely excited about how it can enhance my job and replace repetitive tasks, and I don't see it interfering with my career shortly. You'll need to ask the right question and ensure that the problems you give are very descriptive; otherwise, it is not at the value you hope it will. It has a lot of promise.
I CANT FIND THE ANSWER FOR MY PROBLEM. I NEED TO SUM THE COLUMNS OF ALL MY SHEETS IN A EXCEL FILE BUT ONLY IF THE THE MATCH CERTAIN CRITERIA IN ANOTHER SHEET. EXAMPLE SUM ALL PROFIT FROM ALL SHEETS BUT ONLY IF ITS JUNE
@help with Excel.
In workbook: named D which has l2:m300 data validation list and vba code which help me to select multiple values in each cell and every value is separated by ;.
Problem/question
I took the source from sheet Q, range C2:c60.
My source for data validation changes.
I want: whenever any value changes in c2:c60, it should also change the corresponding cells of l2:m300 cells.
It help me on my job for send queries to the corporative web database using the HTTP POST query method and so to retrieve the data from the production lines automatically, all with excel.
I asked ChatGPT to write a line of VBA code which gives me number of second filtered row, cause I couldn't find it on the Internet (you can find everywhere hints for first filtered row), and within a seconds Chat gave me that and it works.
Second row – > SecondVisibleRow = ActiveSheet.AutoFilter.Range.Offset(1).Resize(ActiveSheet.AutoFilter.Range.Rows.Count – 1).SpecialCells(xlCellTypeVisible)
I'm semi-retired as a local, low level pol! Should I retool as a "maths-man" or a lawyer?"
HI! Is there a really easy way to convert an excel or sheets file to a pdf while preserving the formulas and fillable areas???
work doesn't go away it just changes form
Comments are closed.