#excel

  1. H

    Replace and overwrite excel file without prompt

    Requirements before closing the file: Protect all sheets Hide all sheets except sheet name "Permissions" Replace the file without prompt along with password to open the file (Same file name, Same file path) The below code does not work as required. Not sure where I am going wrong. Private...
  2. H

    Add password to open excel file via VBA

    I am looking for a code which adds PASSWORD TO OPEN FILE in the current workbook before closing it. This will help if the user has removed the protection by applying the password automatically before closing it.
  3. L

    Userform search

    Hi, I have a table with 45 members and let's say 100 columns. Each column is a date and members will have a negative figure within the cell referencing their name and the date if they have a holiday. (EG John Smith is off on 12th June so he would be -8 in cell H22). I want to be able to...
  4. K

    HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST

    # HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST i try target this Drop-down list but not working my Index+match formula .... pleased help this ......& Do Correction my formula.....
  5. C

    How to combine data of the same person into 1 cell

    Hi I have a very badly design report where there's a lot of duplicate data in many rows. (sadly, the IT has not consult me before they launch the system) T-T Basically, I'm working on employee's development plan where one person has more than one row of action plan. I need to combine the data...
  6. H

    Keep source formatting.

    The below code works completely fine. I just want the code to retain the source formatting. For example: my source data also contains numbers which are stored as text, however the below code coverts them into numbers in the output. I don't want the code to convert them instead retain the source...
  7. C

    Postcode finder in Excel and caculate the distance between two postcodes

    Hi, I have seen this code here: Postcode finder in Excel and caculate the distance between two postcodes I would like to understand how could I add my API key to it. How could I add my API key on the code below? Thank you for your help.
  8. K

    Find particular text in Date

    # How to Find particular text in Date ?????? i try to find "2021" in this cell , If Condition is " OK" and if then may be change text like "2020" this condition show "Mistake"
  9. M

    Share Transaction to Inventory in excel VBA using Macro

    Hello guys! I want to write a macro to receive data from the 'Transaction' sheet and gives me an 'Inventory' sheet but I don't know how to do it (the 'Transaction' sheet may contain many shares so the macro should count them all and if we sell a share that we don't have in the first...
  10. C

    Auto Highlight selected field on userform

    Hello, How can you auto higlight selected field on userform? So basicly I need this line to be highlighted (Me.lstDatabase.TopIndex = Me.lstDatabase.ListCount - 1) ListBox1.BackColor = RGB(153, 153, 255) ??????
  11. K

    # How to Extend range in pivot tables ?? ?

    I was try refresh but not show data in pivot table, how to update data ...???
  12. K

    Hide Row with Zero value with Entry

    Hide Row with Zero value with Entry
  13. K

    How replace Range to table name ?????

  14. H

    Copy data till the last row dynamically

    I am trying to copy data dynamically from Cell C1:G till the last row in any of the column in the Range. Attached is the snapshot in which the highlighted area is something I want to copy. Could any one please help me out? Sub TEST1_1() Dim lrc As Long lrc = Cells.Find(What:="*", _...
  15. H

    Copy data using advanced filter across all sheets.

    I am trying to create a macro which copies and pastes filtered data from all sheets of another workbook. The below code does the job but lacks accuracy in filtering data. Please note the database range is same across all sheets of another workbook (Headers on Row no.7) Accuracy Problem: It...
  16. H

    Advanced filter does not equal to a list of IDs from another workbook.

    Hi, I have a list of IDs from range A1, A2 and so on (Including Header in range A1) which I want the code to exclude while filtering the data from another workbook. My criteria range is B25:G26. I tried using <>*ID* by the pasting this in Range B26 (B25 as the header), which ran fine just for...
  17. H

    Copy data using advanced filter from another workbook.

    The below code tries to copy the filtered data from another workbook and pastes it into this workbook. Problem: Expected end of statement error is shown by highlighting the word ACTION. I have no clue why is this error appearing. Could anyone please help me? Sub Import_Data() Dim FileToOpen...
  18. H

    Debug wrong number of arguments or invalid property assignment error.

    I have 7 sheets in total and want to make save as for the first 5 sheets with time stamp and password. The below code gives an error msg "wrong number of arguments or invalid property assignment" highlighting the word FORMAT. This code used to work perfectly before adding the the 7th sheet...
  19. M

    COUNT DUPLICATES IN MULTIPLE CRITERIA

    Hello. I am trying to find the correct formula to count duplicate entries with multiple criteria's. See example below. I need a formula to count all Orders in a spreadsheet that has certain words in that column as well is certain words in another column. I need to find out how many Orders I...
  20. H

    Optimize loop with an if statement.

    About the code: It copies sheet7.RangeB11 till the last used column when the word MAPPED is found in sheet7.RangeA11 and so on; paste them in the said destination. Problem: I have large data set (around 2,00,000 lines) and this code consumes a lot of time when compared to the task implemented...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top