User Posts: Aung
0
How to Copy Cell If Condition Is Met in Excel (7 Easy Ways)
0

Microsoft Excel is a powerful program. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel functions that we ...

0
How to Open VCF File in Excel (2 Simple Methods)
0

Microsoft Excel is a powerful program. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel functions that we ...

0
How to Open CSV with Delimiter in Excel (6 Simple Ways)
0

Microsoft Excel is a powerful program. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel functions that we ...

0
How to Keep Leading Zeros in Excel CSV Programmatically
0

Microsoft Excel is a powerful program. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel functions that we ...

0
How to Adjust Chart Spacing in Excel Clustered Column
0

Microsoft Excel is a powerful program. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel functions that we ...

0
How to Calculate Semi Variance in Excel (3 Simple Methods)
0

Microsoft Excel is a powerful software. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel functions that ...

0
How to Get Simulation Probability in Excel (with Easy Steps)
0

Microsoft Excel is a powerful software. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel functions that ...

0
How to Calculate Percentage Complete Based on Dates in Excel
0

Microsoft Excel is a powerful software. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel functions that ...

0
How to Show One Number as a Percentage of Another in Excel
0

Microsoft Excel is a powerful software. We can perform numerous tasks on our datasets using Excel tools and features. There are many default Excel Functions ...

0
Create Retirement Budget Worksheet in Excel (with Easy Steps)
0

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. There are many default Excel ...

0
How to Create Petty Cash Book Format in Excel (With Easy Steps)
0

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default Excel ...

0
How to Change Date Alignment in Excel (8 Simple Methods)
0

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default Excel ...

0
AVERAGEIFS for Multiple Criteria in Different Columns in Excel
0

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default Excel ...

0
How to Calculate Monthly Average from Daily Data in Excel
0

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default Excel ...

0
How to Use AGGREGATE to Achieve MAX IF Behavior in Excel
0

Microsoft Excel is a powerful software. There are many default Excel Functions that we can use to create formulas. Many educational institutions and business ...

Browsing All Comments By: Aung
  1. Thank you very much. This article shows how you can pull data from different worksheets present in a workbook. However, if you want to extract data from sheets present in different workbooks, kindly go through the article linked below. It will guide you through the complete procedure.

    https://www.exceldemy.com/excel-macro-extract-data-from-multiple-excel-files/

    Moreover, you can create a simple formula:

    =’D:\SOFTEKO\[task_problems.xlsx]Sheet1′!$C$18

    Where D is the drive location, SOFTEKO is the folder name, task_problems is the desired excel file, Sheet1 is the worksheet, and C18 is the required cell value.

    Here, make changes according to your requirements.

    Good luck.

  2. Thank you very much. This article shows how you can pull data from different worksheets present in a workbook. However, if you want to extract data from sheets present in different workbooks, kindly go through the article linked below. It will guide you through the complete procedure.

    https://www.exceldemy.com/excel-macro-extract-data-from-multiple-excel-files/

    Good luck.

  3. We’re very glad to hear that we could be of help to you as well.

    Good luck.

  4. Thank you very much for correcting us. We removed the reference as it’s not really necessary. You just have to color the cells E5 and E6 in blue and orange respectively. This is for the purpose of taking reference in the argument of the function we inserted in cells F5 and F6.

    Thank you again.

  5. We’re happy to help you out. Kindly refresh the worksheet if you change the cell colors. You’ll find the Refresh button in the Data tab. However, if we can improve the code to update it automatically, we’ll let you know.

    Good luck.

  6. We’re glad to know that we could help you out. In the case of the VBA method, kindly refresh the worksheet after you change the color of the cells. You’ll find the Refresh button in the Data tab. However, if we can improve the code to update it automatically, we’ll let you know.

    Good luck.

  7. Thanks for reaching out to us. Please go through the article linked below. I believe that will help to solve your issue. You can also mail us your Excel file at [email protected] and state your conditions.

    https://www.exceldemy.com/merge-two-columns-in-excel/

    Good luck.

  8. Thank you so much for pointing out the issue. We have updated the article. Now it’s alright. Please check.

  9. Thanks for reaching out. Kindly mail me your Excel file and queries at [email protected]
    I’ll be happy to help.

  10. Thanks, glad we could help you.

  11. Welcome ASIM, glad we could help you.

  12. Thanks, LOUIS for reaching out to us. Please drop your excel file and queries at [email protected]
    This is Aung, one of the writers of ExcelDemy. I’d like to help to solve your problem, but I didn’t exactly understand your criteria. I hope you elaborate a bit further.
    Thanks.

  13. Hello SHERRY,

    This is Aung, one of the writers/developers in ExcelDmey. Thank you for pointing out the issue. We have re-uploaded the excel file. Now you can download it without any problem.

    Good luck.

  14. Hello BRIAN,

    This is Aung, one of the writers/developers in ExcelDmey. I’ve looked into your matter. I understand you want to split the cell values. Kindly send me your excel file at [email protected]

    I’ll make the necessary changes and explain them to you.

    Good luck.

  15. Hello BRYAN,

    This is Aung, one of the writers/developers in ExcelDmey. I’ve looked into your matter. What you need to do is just modify your formula. Choose any one from the below 2 formulas:

    =SUMPRODUCT(AA3:AA43,(–(TEXT(I3:I43,”mmmm”)=TEXT(B1,”mmmm”))))

    =SUMPRODUCT(AA3:AA43,(–(MONTH(I3:I43)=MONTH(B1))))

    Both should work perfectly fine.

    Good luck.

  16. Thank you Roger for the beautiful comment.

  17. Thank you ROGER for reaching out to us. Sure you can send me your files at my mail: [email protected]
    I’ll be happy to help you.

  18. Welcome WILLIAM, it’s always a pleasure to hear that we were of any help to you.
    Thanks for the nice comment. Good luck.

  19. Hello SHAWN,
    Thank you for letting us know your queries. Yes, there’s a way to attach a button to run your desired macro. Just insert any shape (Insert > Illustrations > Shapes) in the worksheet. Then, right-click on the shape to get the Context Menu. There, select the Assign Macro option. Hence, it’ll return a dialog box. Choose your desired macro and press OK. In this way, you don’t have to go to the VBA window to press the Run key.
    Hope you can perform the task. Please reach out to me at: [email protected] for further queries.
    Good luck.

  20. Hello COEN,
    Thanks for reaching out to us. Regarding your issue, select the range A1:I30 of Sheet1 first. Then, go to Sheet2. Press the Ctrl key, and select the range A1:I20 simultaneously. Thus, you’ll have selected your desired ranges from both sheets. Now, follow the steps in method 3. In this way, you’ll have your required email body.
    Good luck.

  21. Hello JKS,
    Thank you so much for pointing out the mistake. We’ve uploaded the accurate VBA codes in methods 2 & 3.
    And about your other issue regarding the screenshots, the codes are really long. That’s why we have demonstrated the upper portions only. But the entire code is there.
    Lastly, we are grateful for your feedback. It helps us to grow.
    Good luck.

  22. Thank you Hendry for reaching out.
    I’ve looked into your matter. You can easily carry out the mentioned operation using the 5th method in this article i.e. VBA method.
    Kindly try with VBA and if you still can’t get the job done, feel free to email me. My mail: [email protected]
    Good luck.

  23. Hello DARRYL,
    I’m not sure what you tried to mean by missing colors. The Headers are still blue in the email body. Please reach out to me at: [email protected] for any further queries. I’ll be happy to help.
    Good luck.

  24. Welcome SHAUL. It’s always a pleasure to hear that we were of any help to you.
    Good luck.

ExcelDemy
Logo