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

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top