code2

  1. S

    VBA Create sheet if sum > 0

    Can someone help with VBA code to create a new sheet named "Code2" if sum of column AG >0? Thank you!
  2. A

    Find content in column and sort in specific order

    Hi Guys I am looking for some help with finding some content within a column and re-arranging the order of the found rows to a specific order. To make it a bit clearer please see below <tbody> score1 score2 score3 score4 score5 score6 score7 text text text text text text text 123...
  3. A

    Index match with one criterium in multiple columns

    <colgroup><col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="8"> <tbody> Hello folks unfortunately working with somehow strange set of data...
  4. A

    Index Match with one criterium in multiple columns

    Hello together, unfortunately I have to work with databases like below. People work on days 1 - 5 and do different activities I would be glad to be able to have the data like written in column "J" without workarounds. In this case people who worked on day 3 with activity "c". Thanks very much...
  5. F

    how to highlights the same value with duplicates in another column

    i have multiple employee with the same employee number in column A and a code in column b. how can I highlights the same value with duplicates in column B. Ex: Col A | Col B 1001 code1 1001 code2 1001 code3 1001 code1...
  6. S

    IF "MATCH" is FOUND is myrange THEN "MATCH" - Help needed please

    I'm trying to write in a procedure that will: IF AL2, AM2, AN2 = "MATCH" THEN range("AO").value = "MATCHES" more or less, if the word "MATCH" is found in any of the cells AL2, AM2, or AN2 then I need AO2 to return "MATCHES". If not, then "NO MATCH" then loop it. THANKS GENTS Sub...
  7. S

    Merge spreadsheets by different row quantity

    I have 5 workbooks. We'll call them code1, code2, code3, code4, code5. I need to merge these into one workbook called master. All workbooks only have one sheet named Sheet1. I need to pull 50 records (rows) from code1, 63 records (rows) from code2, 50 records (rows) from code3, 38 records (rows)...

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