I have 2 spreadsheets. One is the Master, the other is called Export. I need to get the numbers from the export into the master (column C) each month based on the item row name and the IDs in column A need to match. I kept trying: IF column B CONTAINS this, then pull in column T from other...
I'm looking to Conditionally Format a cell using a formula for another cell if it does not contain certain letters.
Example:
I need to conditionally format Cell B1 to be a certain color if Cell A1 does not contain "T","TC","M","MC","B", or "BC".
So when I type in anything other than those...
Hi,
I have an excel document that contains 2 sheets. I want to look in the first sheet, in column A if the cells contain words from the list in column A of the second sheet. I do not want to find exact cells, but know which cells contain one or more words (in column A of sheet 2) in the texts...
I want excel to look at a cell and if it contains the word "special" then I want it do run my code. I am not sure how to do this.
Here is what I have so far.
Sub special()
Count = Range("a65536").End(xlUp).Row
For i = 2 To Count
If cells(i,4).value = [contains the word "special"] then...
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.