Search results

Hello Wez, Welcome to the forum! You can achieve this using the SUBSTITUTE function in Excel. Assuming the HTML content with [SWAP] is in column A and the replacement text is in column G, you can use the following formula: Formula: =SUBSTITUTE(A1, "[SWAP]", G1) A1: The cell containing the...

You can use the provided idea to create a solution tailored to your requirements. Instead of selecting ranges individually, consider structuring your data for seamless formula application. For example, ensure consistent headers and column alignment in the Data Sheet. Using structured references...

To accommodate branch-specific matching and summation for duplicate division names, you can use the following formula in Sheet1 or Sheet2: Formula for Sales/Profit: =SUMIFS('Data Sheet'!C:C, 'Data Sheet'!A:A, $B$4, 'Data Sheet'!B:B, A5) Explanation: $B$4 refers to the branch dropdown in...

Hello Muh, You can use the XLOOKUP function to import data from sales and profit sheets. Sales: =XLOOKUP(B4,'Sales 2021'!B3:B25,'Sales 2021'!C3:Q25,1) Profit: =XLOOKUP(B4,'profit 2021'!B3:B26,'profit 2021'!C3:Q26,1) Excel File:

You're very welcome! I'm glad I could assist. Let's keep helping each other and make the ExcelDemy forum a valuable resource for everyone. If you have more questions, feel free to ask. Have a great day!

Hello Shane0278, There are a few issues in your VBA code that might cause a runtime error: Typo in Variable Name (rSH): The variable rSH is used in your code, but it is not declared or assigned anywhere. You likely meant to use Dsh (the data sheet) instead of rSH. Correction: Replace all...

You’re most welcome! I’m glad I could help. Let me know how it works out for you, or if you face any challenges while trying it. I’m here to assist if you need further guidance. Good luck with your project, it’s a great step toward making your work more efficient!

Hello Robbie, Thank you for sharing your detailed approach to structuring the Excel template for tracking employee uniform issues. Your suggestion to use separate tabs for Purchases, Issues, and Inventory, along with dynamic formulas for tracking balances, is both practical and efficient. This...

Hello saim09, Agree! Linking cells between Excel files is a powerful way to keep data synchronized. External references work great for simpler connections, while VBA macros offer robust solutions for complex automation. Ensuring file accessibility and proper storage is key to avoiding broken...

Hello cedie082915, Welcome to the world of Excel! Creating a system to enter cheque details and save them to another sheet is a great idea to keep track of your transactions. Follow the given steps to do it. Step 1: Structure Your Sheets Sheet 1: Use this sheet to input cheque details. For...

Hello, Thank you for clarifying! I now understand that you'd like to maintain the separation of cost areas in your graph, similar to the example provided in the Moneysmart budget planner. You also want the chart to reflect the monthly totals for each cost area from the table AN18:AU30. Here’s...

Hello want2learn, I understand you're aiming to create a chart in Excel that compares individual monthly totals against the year-to-date (YTD) total for each month. Let's work through this step by step to achieve your desired outcome. 1. Organize Your Data: Ensure your data is structured...

Hello Chavezz, That's a smart approach! While the TEXT function works perfectly to extract the day of the week, at ExcelDemy, we often recommend using the Format Cells option with a custom format like dddd to achieve the same result while keeping the original date intact. It's another simple...

Hello Thurley, Here is the updated Activity on Node (AON) diagram, representing the tasks and their dependencies based on the provided data. Each node shows the task ID, description, and duration in days.

Hello Thurley, To create an Activity on the Node (AON) diagram, we need the dependencies for each activity. This information determines the flow and sequencing of activities. If no dependencies are provided, the AON diagram assumes all activities are independent, which is unlikely in most...

Hello Shin, You can achieve this time in and time out using Google Apps Script. Barcode Scanner: Use a USB barcode scanner (plug-and-play) or a mobile scanner app to input the ID into a Google Sheet. Apps Script Automation: Use Google Apps Script to capture the scanned ID, date, time, and...

Hello Rona, You must use the custom format to format the date to show only the day. Select the date cell >> Format Cells >> Custom >> type d. You can watch our video tutorial: How to Create Leave Tracker in Excel

You are most welcome. I'm glad to hear that it worked perfectly. Keep helping each other in the forum to make the community stronger.

Hello Jogec, You can use the following formula: =IF(ISNUMBER(SEARCH("h", A2)), LEFT(A2, SEARCH("h", A2) - 1) * 60, 0) + IF(ISNUMBER(SEARCH("m", A2)), MID(A2, IF(ISNUMBER(SEARCH("h", A2)), SEARCH("h", A2) + 1, 1), SEARCH("m", A2) - IF(ISNUMBER(SEARCH("h", A2)), SEARCH("h", A2) + 1, 1)), 0) +...

You are most welcome. Thanks for your feedback and appreciation. Keep helping each other.