insert a value in a cell

  1. R

    2 macros (click a button) to insert certain text.

    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...
  2. Y

    How to insert column values for specific rows

    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'...
  3. D

    Match Insert

    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...
  4. L

    VLOOKUP: if match found insert cooresponding data in the same row, different column

    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...
  5. D

    Please Help me. Searching for a certain text in a column, and entering yes/no in a certain cell

    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'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