wksdata

  1. A

    How to auto-fill until the last row of data based on user-specified input on a separate worksheet

    Hi everyone, I'm trying to autofill column A in "Master Publisher Content" based on a user-specified value in "Enter Info" in cell H3. The catch is that I only want to fill column A based on the last row of data in "Master Publisher Content." I'm using column C to find the last row of data, but...
  2. A

    How to ignore a blank cell with the criteria with the .Autofilter method

    Hi everyone, I am trying to delete rows based on a value designated in another worksheet --> Enter Info. There are multiple criteria on this worksheet cells A2:A10. The code I have now deletes the rows successfully, however, if the cell in A2 is blank then the program does not run. My question...
  3. V

    AutoFilter Not Equal to More Than 2 Criteria, *Contains* Text - Question

    So, I understand you are limited to only 2 criteria in VBA when using an autofilter with "*contains*" text feature. My code using only two criteria is listed below. I've looked for hours and can't find a workaround to somehow filter with more than 2 criteria. It seems an Advanced Filter...

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