column selection

  1. J

    Search first row for specific string, if found - percentage entire column

    Hi there, I am looking for assistance in writing VBA code to do the following. 1) Loop through the first row of every column 2) I want to identify every column where the first row contains the string "rate" in any variation. 3) Select all columns w/ "rate" in the first row and percentage their...
  2. S

    Sumifs Column Selection based on Aother Cell's Value

    This is my first post and I’m aware it’s a bit of a long one. Sorry! I'm looking to use a sumifs formula (which I have working on a single column) over a range. I've searched extensively online, but can't seem to find a way to do what I want to do - maybe a search terms thing?!?!? I have an...
  3. R

    Selection of Column

    Hello I want to Select the data from the column, where i am using a code which select first last cell value from down and then i want to select the data from that cell value, but i dont want to select the first row(header of table) for that I am using following code...
  4. G

    User form for selecting and copying columns to another worksheet

    Greetings to all you señor Excels! I have an Excel sheet that has approximately 25 columns and a continuously growing number of rows as it serves as a simple database. What I'm trying to achieve is to have a Form Control button which upon pressing would pop up a window (user form) that would...

Watch MrExcel Video

This Week's Hot Topics

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
Top