cad

  1. A

    Data Validation List based on Cell Value

    I have a table in which currency in A and values in B <tbody> CAD 2 USD 13 AUD 15 CAD 5 CAD 11 </tbody> I enter text CAD in C1 and make data validation list in D1. Based on text in C1 data validation only shows the value against CAD. like image attached.
  2. E

    How to combine two table information?

    Hi, Can someone please help me with this: I have a table with these columns: <tbody> Product Original currency Jan-16 Feb-16 ... Dec-16 Total 2016 in original currency Total 2016 in CAD A USD 3 5 8 XX (3*1.3)+(5*1.28)+...+(8*1.294) C EUR 3.4 3.2...
  3. 2

    Multiple ISBLANK Query

    <colgroup><col><col><col><col></colgroup><tbody> ORDER STATUS CAD PENDING DIE PENDING STONE PENDING CAD PENDING </tbody> These are my 4 columns, if (Column 2,Row 2) -> CAD pending cell is blank , then Order status(Column1,Row2) should show CAD PENDING, if (Column 3,Row 2), DYE PENDING is...
  4. I

    VBA is *not* empty

    This code works for empty cells How can I amend it to work when the cells in column C has a value of "No" for example? Many thanks Sub System_Check() Dim cell As Range, c As Range, cad As String lr = Cells(Rows.Count, 1).End(xlUp).Row On Error Resume Next Set cell =...
  5. L

    Listing the values that were added by COUNTIF/SUMIF or gettign the summary of the values (

    Hello, I have an excel with a lot of data (attached excel is just a small portion of it). In this excel, my primary objective is to find the EFFORT by each RESOURCE to each PROJECT. If i use SUMIF, i get the total effort for each resource easily. However, I want to know list the PROJECTS and...
  6. R

    sumifs dynamic critiria

    So i have a drop down (B2) that is fed from COL 1 of the Help table Depending on Which is selected my SumIfs either has no criteria (All the whole dataset), Region (Use Col 1 of the data Table and only add matches) Region-District (Use COL 1 & COL 2) Col M = Sales A dynamic Criteria based on...
  7. X

    Two filters to select values and paste unique in another sheet

    I have data as below Currency Location CAD 00002 CAD 00004 CAD 00005 CAD 00002 USD 00001 USD 00002 CAD 00006 CAD 00004 CAD 00005 USD 00001 I want to filter for CAD, then select the Location...
  8. G

    CAD/DWG en Excel

    Has anyone experience with EXCEL and DWG? I want to select (with mouse) an object in a DWG-file. This selected object i want to drop in excel, where i can see the information. I don’t have a CAD appliction, like ACAD, installed. Please help me.
  9. G

    CAD/DWG en Excel

    Has anyone experience with EXCEL and DWG? I want to select (with mouse) an object in a DWG-file. This selected object i want to drop in excel, where i can see the information. I don’t have a CAD appliction, like ACAD, installed. Please help me.

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