column a

  1. J

    Copy column data from worksheet to .htm file (notepad) using VBA

    Hello, its my first time here. I am really new to VBA and only know some basics but Im looking for something a bit more complex. I have built an excel database which creates web pages by using formulas to pull in data that changes page per page. The generated HTML is in a worksheet called 'P1 -...
  2. E

    Delete Rows Where Column A Does Not Equal a Number or Numeric Value

    I thought I would be able to find a macro for this but could not. Pretty straight forward. "Delete Rows Where Column A Does Not Equal a Number or Numeric Value" Anyone have a solution? Thanks!
  3. S

    VBA if cell contain text

    Hello, I'm trying to create a VBA that states if within Column A if there is a text then paste to the right. If the cell in column A has a numeric value then do nothing. <tbody> a b 1 john 2 1 3 3 4 jake 5 bill 6 7 </tbody>
  4. G

    How to remove two first and two last characters from a column in Excel with one formula?

    Hello. I have my column A in Excel like this: LT013800 LT025200 PL2011000 PL2061000 LV440200 LV604300 EE440000 EE700000 etc. And I want my column B like this(so I want to remove two first and two last characters from column A using one formula): 0138 0252 20110 20610 4402 6043 4400 7000 etc...
  5. G

    Freeze Panes

    Is there a way to freeze column A, but not for scrolling left and right, but up and down? Like I want columns C and on to scroll up and down, and column A just stay put and not scroll up and down with the rest of the page.
  6. A

    Find a value in a column and then fill some cells in that row. Everything using InputBox

    Hello MrExcel, excuse me if I make a mistake with the language, because English is not my own. I want to press that command button that pops an InputBox and put a number in it, like the picture. That happens in sheet "Sizes". Then I want that value to be searched in Column A of the sheet...
  7. H

    Email after column A has a change

    Hi all! I'm having trouble figuring out what is wrong with my excel macro, I am trying to run this macro that when a value in column A (it can only be 3 values S, C, or D) changes it sends an email to the appropriate person. For example if it is changed to S it sends an email to S@email.com and...
  8. MaxWol

    Remove different rows in 2 sheets

    Hi all, I have two sheets. Sheet 1 has 73.619 rows and sheet 2 has 41.470 rows. The values of column A in sheet 2 appear randomly in column A of sheet 1. I want to do 2 things: 1. I want to delete all rows in sheet 1 that have a value in column A that can not be found in column A of sheet...
    • MaxWol
    • Thread
    • column a different values remove rows sheets two sheets
    • Replies: 1
    • 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