I need 2 macros, one for a button when clicked to insert the text "NO", a second macro for a button when clicked to insert the text "YES". Both in range "B7:B200".
Meaning if I click the button "NO", it will insert the text "NO" in first cell from range "B7:B200", meaning B7. After that if I...
Hi everyone,
I currently have a csv file that consists of 600,000plus rows of data
I would like to insert value 'Malicious' into the column H, 'Class' for all rows of data that contains values 147.32.84.180 or 147.32.84.170 which appears in either column C or column D, and value 'Bakground'...
I have two worksheets. One has a project Code with corresponding reference codes in the cell to its right. Altogether there are several hundred project codes and about five corresponding reference codes which match. (More than one project code can match a single corresponding reference code but...
This is my first post...an ANY forum. I am also pretty new to formulas other than your basics. Here's my problem:
I used vlookup (with help) to find out if the vendor part number I have for a part matched the actual vendor part number for the same part. If it matched, it inserted that vendor...
Im am looking to create a schedule template where:
Row #1 has Monday - Sunday
Column A has a list of employee names
The employees work at certain stations 1-15 that will be placed under certain days of the week in their row.
I want a reference column to the right of this table that lists all...
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.