Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

User Posts: Mashhura
0
How to Change Date Range in Excel Chart (3 Quick Ways)
0

If you are looking for a way to change the date range in an Excel chart easily and quickly then you have come to the right place. The objective of this article ...

0
How to Use COUNTIFS for Cells Not Equal to Multiple Text in Excel
0

The COUNTIFS function gives you the opportunity to provide more than one criterion and returns the count of cells that meet all the criteria at the same time. ...

0
How to Use COUNTIF for Non Contiguous Range in Excel
0

The COUNTIF function is one of the statistical functions. This function is used to count cells that meet a certain criterion. The focus of this article is to ...

0
How to Translate Excel File from English to Gujarati (2 Easy Ways)
0

Whenever working with Excel, you may face situations where you will need to translate your file or data into other languages. This article aims to explain how ...

0
[Fixed!] Excel VLOOKUP Not Returning Correct Value
0

Excel VLOOKUP function is a very useful function. You can find out your needed data from a big range of data easily by using the VLOOKUP function. But ...

0
[Fixed!] Excel Filter Not Working After Certain Row
0

Excel Filter feature helps to filter data according to your need. It is a really helpful feature. But, sometimes it does not work properly. The objective of ...

0
[Fixed!] Move or Copy Sheet Not Working in Excel
0

Move or Copy sheet is a very useful feature in Excel. You can move or copy worksheets by using this feature. But, sometimes you may face a situation when the ...

0
How to Convert Excel File to Google Sheets Automatically (3 Ways)
0

If you are looking for a way to convert your Excel file to Google Sheets then you have come to the right place. The objective of this article is to explain how ...

0
How to Copy and Paste Pivot Table Values with Formatting in Excel
0

If you copy a pivot table and then paste it, you will get the pivot table. But, if you want to copy the values of a pivot table with the formatting, it can be ...

0
How to Convert Excel to VCF Without Software (With Easy Steps)
0

If you are looking for a way to convert an Excel file to VCF without using any software, this article will be helpful for you. The focus of this article is to ...

0
How to Edit CSV File in Excel (3 Simple Ways)
0

You can open a CSV file in Excel and edit the data to get a more clear idea about the file. The main objective of this article is to explain how to edit CSV ...

0
How to Attach PDF File in Excel (3 Easy Ways)
0

Whenever working with Excel you may face a situation where you will need to attach PDF files in Excel. The main focus of this article is to explain how to ...

0
How to Concatenate If Cell Values Match in Excel (7 Easy Ways)
0

If you want to represent the values that match certain criteria in a cell then this article will be helpful for you. The main objective of this article is to ...

0
[Fixed!] Cannot Delete Comment in Excel (3 Suitable Solutions)
0

Comments help you to mention something about data. But after you are done with the comments you may want to delete them. Deleting comments is quite an easy ...

0
[Fixed!] Excel Text to Columns Is Deleting Data
0

Text to Columns is a very useful feature in Excel. This feature is generally used to separate data into multiple columns that are stored in a single column. ...

Browsing All Comments By: Mashhura
  1. Hello ZAIN,
    Thanks for your comment. I am replying to you on behalf of ExcelDemy. For Example 5, you will have to keep 2 things in mind.
    1. You will have to change the ColumnCount in the ListBox Properties according to your dataset.
    2. In the VBA code, you will have to change Row and Column numbers according to your dataset.
    I hope this will help you to solve your problem. If it fails to solve your problem, then please specify where are you facing the problem.
    Regards
    Mashhura,
    ExcelDemy.

  2. Hi XIONG YANG,
    Thanks for your comment. I am replying on behalf of ExcelDemy. You can not add a label directly in the QR Code. But, you can add a label to the cell where you are inserting the QR Code by following these simple steps.
    Step-01: Write the following VBA code in the module instead of the code that is provided in this article.
    Function GenerateQR(qrcode_value As String)
    Dim URL As String
    Dim My_Cell As Range
    Set My_Cell = Application.Caller
    URL = "https://chart.googleapis.com/chart?chs=100x100&&cht=qr&chl=" & qrcode_value
    On Error Resume Next
    ActiveSheet.Pictures("My_QR_CODE_" & My_Cell.Address(False, False)).Delete
    On Error GoTo 0
    ActiveSheet.Pictures.Insert(URL).Select
    With Selection.ShapeRange(1)
    .Name = "My_QR_CODE_" & My_Cell.Address(False, False)
    .Left = My_Cell.Left + 5
    .Top = My_Cell.Top + 5
    End With
    GenerateQR = ActiveCell.Offset(0, -1).Value
    End Function

    Now, Save the code and go back to your worksheet.
    Step-02: Select the cells where you want the QR Codes >> go to the Home tab >> select Bottom Align.

    Step-03: Select the cell where you want the QR Code >> write the following formula in that cell.
    =GenerateQR(B5)

    Next, press Enter and you will get the QR Code with the Label.

    Step-04: Finally, get the QR Codes for other data in the same way.

    I hope this will help you to solve your problem. Please let me know if you have other queries.
    Regards
    Mashhura,
    ExcelDemy.

  3. Hey ERIK NIELSEN,
    Thanks for your comment. I am replying to you on behalf of ExcelDemy. If you want to get metadata from subfolders of the specified source folder then you can use the jamsoftware that is used in the “How to Export File Metadata to Excel” section of this article. Let’s see the steps.
    • Firstly, download and then copy and paste the FileList.exe file to the folder from where you want to get the metadata by following the steps from the “How to Export File Metadata to Excel” section of this article.

    • Secondly, press Windows Key + R.
    • Thirdly, write cmd in the Open section.
    • Then, select OK.

    • After that, write cd C:\Images. Here, C:\Images is the source folder path.
    • Then, press Enter.

    • Next, write the command below.
    FileList.exe /USECOLUMNSNAME,FULLPATH,LASTCHANGE,EXTENSION,SIZE, AUTHORS,System.Photo.DateTaken > output.txt
    • Then, press Enter.

    • After that, minimize the window.

    • Now, you will see a txt file is created in your selected location. It contains the metadata from all the subfolders.

    • Next, open an Excel file >> go to Data tab >> select From Text/CSV.

    • Afterward, select the txt file >> select Import.

    • Now, you will see the metadata are imported to a table.
    • Then, select Comma as Delimiter >> select Load.

    • Finally, you will see all the metadata from the subfolders is loaded to an Excel sheet.

    I hope this will help you to solve your problem. Please let me know if you have other queries.
    Regards
    Mashhura,
    ExcelDemy.

  4. Hey MARK,
    Thanks for your comment. I am replying to you on behalf of ExcelDemy. For the provided practice workbook, I used the following VBA code and it solved this problem for me.

    Function QR_Generator(qrcodes_values As String)

    Dim Site_URL As String
    Dim Cell_Values As Range

    Set Cell_Values = Application.Caller
    Site_URL = "https://chart.googleapis.com/chart?chs=100x100&&cht=qr&chl=" & qrcodes_values
    On Error Resume Next
    Worksheets("Using User Defined Function").Pictures("Generated_QR_CODES_" & Cell_Values.Address(False, False)).Delete
    On Error GoTo 0
    Worksheets("Using User Defined Function").Pictures.Insert(Site_URL).Select
    With Selection.ShapeRange(1)
    .Name = "Generated_QR_CODES_" & Cell_Values.Address(False, False)
    .Left = Cell_Values.Left + 2
    .Top = Cell_Values.Top + 2
    End With
    QR_Generator = ""

    End Function

    Now, Save the code and go back to your worksheet. Let’s see the steps of using the function.
    Step-01: Select the cells where you want the QR Codes. Here, I selected cell range D5:D7 >> write the following formula.
    =QR_Generator(C5)
    Writting Formula
    Step-02: Press Ctrl + Enter and you will get your desired output.
    Getting Result
    I hope this will help you to solve your problem. Please let me know if you have other queries.
    Regards
    Mashhura,
    ExcelDemy.

  5. Hi TIAGO,
    Thanks for your comment. I am replying to you on behalf of ExcelDemy. You can get the correct value by using the COUNTA function instead of the SUM function. Let’s see the steps.
    Step-01: Write the following formula in the selected cell.
    =E5/COUNTA($C$5:$C$16)
    Text average formula
    Step-02: Press Enter to get the Average.
    Text Average result
    Step-03: Drag the Fill Handle down to copy the formula to the other cells.
    Using Fill Handle
    I hope this will help you to solve your problem. Please let me know if you have other queries.
    Regards
    Mashhura,
    ExcelDemy.

  6. Hello Alun Vaughan-Evans,
    Thanks for your comment. I am replying to you on behalf of ExcelDemy. There is a way to keep the formatting and also values. You can follow these steps to do that.
    Step-01: Select the range you want to copy and then copy the range by pressing Ctrl + C on your keyboard.
    Step-01
    Step-02: Select the cell where you want to paste the range. And then go to Home > Paste > Values & Source Formatting (like the following image).
    Step-02
    Finally, you will see that you have copied the values with formatting.
    Final Output
    I hope this will help you to solve your problem. Please let me know if you have other queries.
    Regards
    Mashhura
    ExcelDemy

  7. Hello JC,
    Thanks for your comment. I am replying to you on behalf of ExcelDemy. The downloaded file works for me.
    You can follow the steps from the Feature of Eisenhower Matrix Template in Excel section. If it still doesn’t work then check if all cells contain the formula in the Eisenhower Matrix.
    And, while making your own Eisenhower Matrix, check if you are applying for the same range as in this article. If not, change your ranges accordingly in the formula.
    Lastly, if you are using an older version of Microsoft Excel then press Ctrl + Shift + Enter while entering the formula.
    I hope this will help you to solve your problem. If none of these works then you can let us know at [email protected] with your Excel file and problem details. We will try our best to solve your problem.
    Regards
    Mashhura
    ExcelDemy

  8. Hi SEM,
    Thanks for your comment. I am replying to you on behalf of ExcelDemy. If you want to filter dates older than a number of days from today, you can follow the steps from Method-2. But, instead of the formula used here, write the following formula.
    =C5<(TODAY()-30)

    Here, I wrote the formula for dates older than 30 days from today. You can change the formula according to your preference.
    I hope this will help you to solve your problem. Please let me know if you have other queries.
    Regards
    Mashhura
    ExcelDemy

  9. Hi Penny,
    If you check to see if the cells are blank or not then they will be evaluated as not blank because the cells contain formula. If you need blank cells then you can follow these steps.
    Step-01: In a Helper Column use any of the formulas from this article. But instead of an empty string ("") write a letter or a special character ("#") in the formula.
    =IF((D5*E5)>2000,D5*E5,”#”)

    Step-02: Copy the values from the Helper Column and Paste them as Values where you want the final output.

    Step-03: Press Ctrl + H and the Find and Replace dialog box will appear. Replace # with nothing and you will get your blank cells.

    Finally, if you check the cells, then you will see the cells are blank.

    I have shared the necessary images for your convenience. I hope this will solve your problem. Please let me know if you have other queries.
    Thanks!

  10. Hello DQNOK,
    Thank you for your feedback.

  11. Hello Frank,
    This article contains different methods for different situations. Method 1.3 hides the numbers that are less than Zero. But, if you want to hide zeros only then you can try the following code.

    Option Explicit
    Sub Hide_Rows_With_Zero()
    Dim row As Long
    Dim col As Long
    Dim qq As Boolean
    For row = 6 To 14
    qq = True
    For col = 2 To 4
    If Cells(row, col).Value <> 0 Then
    qq = False
    Exit For
    End If
    Next col
    Rows(row).Hidden = qq
    Next row
    End Sub

    I hope this will help you to solve your problem. Please let us know if you have other queries.
    Thanks!

ExcelDemy
Logo