advanced criteria

  1. C

    VBA check multiple cells if empty put text in cell B

    What I want to do is try to figure out a macro or code that can check if there is data in column D but column Q, R, and T are empty then I want to place the word "New" into column B. Any Idea's? Thanks as always
  2. S

    Cycle and paste between workbooks with VBA

    So What I need to do is copy and paste the values from the green columns in workbook 1 into workbook 2 if its says "yes" in the last column. I then need to cycle to the next row in workbook 1 and paste the values into a NEW worksheet in workbook 2 and do the same until it no longer says yes in...
  3. S

    Matching values between sheets and then replacing VBA

    I need to search the 2nd column of the DATA tab and see if it matches the first column of the INDEX tab. If so I need to replace the 2nd column in the DATA tab with the value in the second column in the INDEX tab and then scroll through all rows of the DATA tab and do the same thing example...
  4. L

    Advanced nested if with several conditions

    https://docs.google.com/spreadsheets/d/16usEk9KrUYyuaZImKxybGZaiLzWUzk-qegXXrN5r7rc/edit?usp=sharing <bdo...
  5. P

    Advanced Filter Wildcard using Formula

    I'm able to use advanced filter with wildcards that are values only. How do you use wildcard advanced filter using a formula. Sheet3 <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 87px"> <col style="WIDTH: 64px"></colgroup> <tbody> A B 1 Column A...
  6. R

    Brain teaser. Please I need help anybody. My vba coding nightmare

    I have been playing around for a while now but no matter how hard I try I just can't get my vba coding to work for what I'm trying to do. I have had some limited success with match and index and then removing duplicates witch seemed to give me almost what I needed. Ok so this is what I'm trying...
  7. C

    Help with Advanced Sum Function (Sumif/Sumproduct Combo)

    Hi all, Long time user, first time poster, so I know I'm coming to the right place! Anyway, I had a friend reach out to me for some help with an excel formula she is trying to write. She has a table of data with Deal Numbers in the first column, a Strategy ID in the second, an associated date...
  8. L

    Moving each subsequent row over one column

    I would like to take a column of data (numbers or text) so I can use it for an Advanced Search Criteria and change it from: <tbody> ID# 264 372 521 601 784 </tbody> to . . . <tbody> ID# ID# ID# ID# ID# 264 372 521 601 784 </tbody>
  9. L

    Prepare for Advanced Search by moving each subsequent row over one column

    I would like to take a column of data (numbers or text) so I can use it for an Advanced Search change it from: <tbody> ID# 264 372 521 601 784 </tbody> to . . . <tbody> ID# ID# ID# ID# ID# 264 372 521 601 784 </tbody> Any help is appreciated!
  10. J

    Advanced Filter Criteria Range Help

    I have a master list of all of our parts for our inventory system as seen below <TABLE style="WIDTH: 959pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1279><COLGROUP><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH...
  11. M

    Stop New Items appearing in filtered Pivot table items

    Hi, I have a straight forward enough question but can't seem to find a straight forward way of doing it. In short, I have a Pivot Table based on a list showing say, Sales person, product category and quantity ordered. I set up a pivot table showing product category and sum of quantity...
  12. A

    queries- how to query data that meets a condition in FieldA OR another condition in FieldB

    I want to run a query that gives results where EITHER 1.) field A is not blank (Is not null) or 2.) field B is not blank i know how to return results where BOTH conditions are true, but i do not know how to query so that all results are returned where one or the other criteria are true. please...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top