Recent content by shamimarita

You are using the Shell function to start WB2 from WB1. But in VBA it starts a program asynchronously, which means it doesn't wait for the program (or in your case, the workbook) to finish executing before it continues with the next lines of code in WB1. It may be causing WB1 to read the...

Hello JeffVLC, You can download the practice workbook from the article's Download Free Template section: Download Free Template

Hello Paul, Please share your sample workbook. You can use dummy data. Otherwise, it won't be possible to understand the value of your mentioned ranges.

You can use this formula : =IFERROR( IF(D5=0, "",IF(D5>0, IF(...

Dear Jululian, I hope you are doing well. I've used the ROUNDUP and ROUND formulas to avoid the decimals in rank. Where numbers are rounded up if the decimal values are less than 0.5, or rounded and added +1 to the next integer if they are equal to or greater than 0.5. You can change the...

Hello Hajjash, I hope you are doing well. You can use the absolute reference if you don't want the autofill or auto increase of rows and columns. Here is the updated formula. =SUMIFS('Calendar Tracker'!$O$2:$O$1517, 'Calendar Tracker'!$B$2:$B$1517, "="&$B36,'Calendar Tracker'!$H$2:$H$1517,"<>")

Hello Sweetbrwnshugar, I hope you are doing well. I've used a combination of different functions. I applied it to all the attendance codes in your Excel file. Note. Don't use the same code multiple times, try to use unique codes. Use VAC-P instead of P-VAC. Here is the formula...

Hello Spidey, You can manually follow the articles to create a data entry form manually or by using VBA. How to Create Data Entry Form in Excel How to Create Data Entry Form in Excel VBA

Your post is not clear. Kindly specify the problem and your expected result so that we can help you.

You can swap your Emp Id column. Keep your lookup array (Emp Id) on the left side. I've inserted an image and attached the Excel file for your better understanding. Or you can use the VLOOKUP function with the IFERROR function. It will give the same result as the XLOOKUP function. Kindly...

Hello Ashish, Hope you are doing well. Please tell me one thing, in which Excel version are you using the XLOOKUP function?

Kindly open a new thread with a new problem to get a reply and solution quickly.

You are welcome.

Can you please tell us which version of Excel you are using? If you use Excel 2010 and later versions you can use the VLOOKUP function mentioned above. Here I am attaching a drop-down list with the previous formula so that if you enter any value in E4 cell then you will get the respective HSN...