Search results

Hello kolarj, Thanks for sharing your problem with us. I understand you are looking for a formula to return a value based on condition. Developing a formula for the condition and output you require is possible. As I don’t have your dataset, I have taken the following dataset: Assuming that...

Dear Nikhil Patki, Thanks for reaching us. I understand that you are not able to update or refresh Pivot Tables in your worksheet. This may happen if the Pivot Table in your worksheet is linked to another Excel file and this source file is moved, renamed, or deleted. I have shown a similar...

Hello Nikhil Patki, Thanks for sharing your problem with us. From your problem description, I understand that the Pivot Table in the workbook transferred from your office desktop to the home desktop is linked to the office desktop path instead of the home desktop path. This can happen only if...

Dear eral, Thanks for your feedback. As your previous post didn’t mention anything about the automation process, I focused only on generating the S >> S >> S >> OFF >> L >> L >> OFF pattern. However, if you want the monthly roster to change automatically whenever you change the shift of an...

Dear Nikhil Patki, Thanks for sharing your problem with us. Based on your description of the datasheet, I created the following variables: Using these variables, I created the following dataset and inserted slicers. When I click on specific slicers, the filtering works as expected. But in your...

Hello Nikhil Patki, Thanks for sharing your problem with us. I understand that you are facing issues while working in the Excel 2013 version with an automated workbook that was created with the Office 365 version. As you haven't mentioned the exact error message, it is not possible to...

Hello eral, Thanks for reaching us. From your problem description, I understand that you want the following pattern: S >> S >> S >> OFF >> L >> L >> OFF It seems like your employees follow a pattern of 3 consecutive S shifts, a day off, 2 consecutive L shifts, another day off, and so forth. The...

Dear محمد البني, Thanks for reaching us. I understand that you want to link cells from a full page in a file and calculate the total value in column C of another file for corresponding dates. To demonstrate this problem, I have taken the following dataset in Sheet2 of Book1 workbook. It contains...

Hello Nikhil Patki, Thanks for reaching us. I understand that you want to avoid -ve numbers in the 1st Instal Bal column. You also want the excess amount to be added to the next installment balance when adjusted. We can accomplish your requirements using two simple formulas using MAX, MIN, and...

Hello jdcalamia, Thanks for sharing your problem with us. I understand that you want to create a shift roster. You can read the following articles: How to Make a Roster in Excel How to Create Shift Roster 24×7 with Excel Automation These articles contain detailed steps for creating an employee...

Hello AMANZ, Thanks for your feedback. Some authenticated sites generate a session cookie and send it back to your browser to maintain your authenticated session as you navigate through the site. The "From Web" feature that we suggested in our previous response doesn't automatically handle the...

Hello Jokerman, Welcome to ExcelDemy and thanks for sharing your problem with us. I understand that you want to calculate percentages of a subject figure based on conditions. We can achieve that by using nested IF functions. To demonstrate your problem, I have taken the following dataset...

Hello Shellsyt, Welcome to ExcelDemy and thanks for sharing your problem with us. I understand that you want to sum up the accruable hours for each employee listed in the “Payrun Hours Table” worksheet and bring them to the “Staff List” worksheet. We can achieve this by using the SUMIFS...

Dear Vishnukumar, I checked the code present in the previous workbooks. I took a few records with expiration dates that have already passed. These dates include yesterday's date or earlier dates. When I ran the code, the emails were sent properly. The following video shows an overview of the...

Hello bigme, Thanks for your feedback. From the screenshots you provided in the first post, I understand that you want to add new sheets and add data to specific sheets in a Master.xlsx file from a .xlsm file. You wrote the necessary code in a Private Subroutine and then called it within another...

Hello bigme, Thanks for sharing your problem with us. The "Subscript out of range" error can have a few different causes, and the behavior you described, where it runs from the Visual Basic Editor but not from Excel's View tab, may be related to the scope and visibility of objects or variables...

Dear Vishnukumar, I set the same expiration date for all the rows and then executed the code. Only one mail was sent. However, I got 127 complete rows and 1 partial row (like in the following image). This is because the message is clipped. We can click the View entire message command to view all...

Hello ExcelGuy123, Thanks for sharing your problem with us. I understand that you want to add dates to the beige-colored cells in columns F, I, L, O, R, U, and X and put the corresponding value to the merged Cell A1:A2. The Excel formula (combination of INDEX, MATCH, and MAX functions) you used...

Dear PJR, Thanks for your feedback. Yes, you are right. The TEXTJOIN function isn't available in Excel 2016. In that case, we can use the CONCAT or CONCATENATE function. Here, I will use the CONCAT function. The modified formula for Cell B1 is: =CONCAT(INDIRECT("'" & A2 & "'!B2"),"...

Dear Duane, Thanks for your feedback. To return the sum of the cells from Column D for which the feedback cells are empty and match is available Regional criteria, you can use the SUMIFS function. Insert the following formula in L3 and drag down the Fill Handle icon to copy the formula in the...