find and replace vba

  1. K

    VBA codes to replace all cells containing a certain value

    Hello VBA experts, I have a workbook with tons of formula similar to below but with different column and row number. e.g. '=SUM('2022!W6, 2021!W6, 2020!W6, 2019!W6, 2018!W6)' '=SUM('2022!Z6, 2021!Z6, 2020!Z6, 2019!Z6, 2018!Z6)' And every year, when there is new data e.g. 2023, i have to add...
  2. C

    Find and Replace Macro for Excel (If x exists then replace y with x) - For Microsoft Excel

    I created a macro in excel that runs a specific report for me and it works beautifully. I want to upgrade this macro to replace the "Insert Association Name" with the name of the specific community. That community name can be found in every report in the details column. For this one in...
  3. V

    Macro code to find and replace text in different worksheets based on master worksheet data

    Worksheet Name| Find text|Replacing Text Sheet2 | Table A |Table 1 Sheet2 | Table B | Table 2 Sheet3 | Table A | Table 3 Sheet3 | Table B | Table 4 Sheet4 | Table A | Table 5 Sheet4 | Table B | Table 6 I have a master worksheet - Sheet1 with the above data My requirement is such that I need to...
  4. J

    Sorting payroll worksheet alphabetically using VBA

    Hi, I have almost no knowledge of VBA, and need help with this. I have a payroll spreadsheet with monthly worksheets containing employee codes, names, hours worked per day, overtime calculations, Sunday pay calculations, etc. I need help with the ffg: 1. For every month's worksheet I need to...
    • jeevesk
    • Thread
    • find and replace vba payroll sorting alphabetically
    • Replies: 0
    • Forum: Excel Questions

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
Back
Top