noncontiguous columns

  1. S

    Extract column data from non-contiguous columns based on header text with duplicate headers

    Hi all, I am attempting to extract full columns of values only when the column header cell contains specific text in a large matrix where those headers are repeated (due to testing under multiple conditions.) I have attached an example sheet. I would like to make the measures contiguous (e.g...
  2. D

    Auto Copy values from row above based on cell value

    Hello, I'm new to VBA. my issue is this: If c7=c6 then d7,e7,f7, as well as p7:u7 (notice they are not consecutive) should auto fill with the values in their respective columns from the row above (row 6). I have a code, but if I include "If IsEmpty(ActiveCell.Offset(i, i).Value) = False...
  3. S

    Getting the absolute column number from a non-contiguous match result.

    Hi All.... I'm using this : MATCH(M45,CHOOSE({1,2,3},X45,Z45,AC45),0) ...to find the index of the value that matches M45. But what I really need is the absolute column number, which I'm pretty much staring at ... either X, Z, or AC ... numerically though. It must be simple, I'm hoping...
  4. M

    Selecting nocontiguous columns

    Hello and thanks in advance, I am trying to select 2 noncontiguous columns. My code that doesn't work is below: CODE STARTS HERE: Activesheet.Range("A4:A" & FinalRow, "D4:D" & FinalRow).Select Selection.Copy END OF CODE. What happens is that columns B and C get selected also. I tried the...

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