really useful vba code here PK I do like it so much.

@PKAnExcelExpert

7 ай бұрын

Glad to hear that

Excellent Tips sir your every video is super.

@PKAnExcelExpert

7 ай бұрын

So nice of you

Nice 👍❤

@PKAnExcelExpert

7 ай бұрын

Thanks ✌

You know it's a new trick to learn when PK uploads,thanks for the video 👍

@PKAnExcelExpert

7 ай бұрын

Most welcome🙏

Thank you so much Sir

@PKAnExcelExpert

7 ай бұрын

Most welcome

Thanks!

@PKAnExcelExpert

7 ай бұрын

Welcome!

Hi pK, Pls make a macro. Criteria= We have 1 workbook, there have 2 sheet. Both sheet 1st column same but data different. We need fillter out both sheet from first column one by one and save both filtered data in new workbook and save in my drive

U can also make video of SQL server tutorial

@PKAnExcelExpert

7 ай бұрын

I will try.. Thanks

Sir Can u please make a Tableau Video Tutorial

Hi PK. How do we tackle the same if all the characters in the source are in capital letters or small letters? Thanks in advance.

@PKAnExcelExpert

7 ай бұрын

We need to have some other logic to identify that where we should add space.

@Sraghvi1307

7 ай бұрын

@@PKAnExcelExpert Thanks. Request if you can help me with that. Thanks in advance Dr Krishna S

Sir mri aak problem hai ho sak to plizz help kr do ... Dout yaa hai ke mra pass roj mor then 6 to 7 lacks data ho ta hai Orr muj aak dusri worksheet sai Vlookup kr na ho ta hai jis mai mra more then 2 to 3 HR naila ja ta hai .... Iss dout k lia kouch ho sak ta hai kya sir ji...

The link to the practice file seems to go to the wrong file

@PKAnExcelExpert

7 ай бұрын

It is working. Please check again.

What is the use of Application. Volatile in code, Please explain..

@PKAnExcelExpert

7 ай бұрын

Normally, a UDF in Excel only recalculates when any of its arguments change. However, by using Application.Volatile, you tell Excel to recalculate this UDF whenever any recalculation happens in the workbook, regardless of whether the specific inputs to your UDF have changed