drawing

  1. R

    Counta with If

    For whatever reason, I'm drawing blanks on this one. I'm currently using =COUNTA(tblCourses[Name]) to count the number of courses I have. I had to add a column to my table, tblCourses[State] and I intend to type "Inactive" if the course is no longer available. How could I modify the counta...
  2. M

    Automatically inserting row after enter, but range will change.

    Hello, I'm having a problem trying to develop a code that will enable me to automatically insert a row as enter is pressed. Sounds easy, problem is this needs to happen throughout the excel sheet. There are titles to drawing packages in the sheet, two blank spaces between each title. As...
  3. M

    Defining shape dimensions

    Hi Dears, I am trying to draw a 3d box (shape type 14) with VBA, but I cannot find the required parameter to define its depth. The width and height parameters are very clear, but I am unable to change the default depth of this shape. The command used to draw the box is; DIM MyShaep as Shapes...
  4. N

    Corrupt drawing in Excel

    Hi all, I'm getting an error message whenever I open up a particular workbook - it asks me to repair, if I say yes I get a dialog box that says "Excel was able to open the file by repairing or removing the unreadable content - Repaired Records: Drawing from /xl/drawings/drawing20.xml...
  5. U

    Multi-Criteria Vlookup Formula Not Working

    Hello All, I have a Transmittal column on a Drawing Schedule worksheet that I want to auto populate whenever users add transmittal data (This is being done by VBA Already and is working fine) to another sheet that is the Transmittal Log. some things to be aware of, this vlookup has to meet...
  6. R

    Specific result from Vlookup

    Hi, I,m trying to vlookup one cell value with the other. And I got the result also. But I want only one particular result if the cell values are matching. Rest results I want to keep blank even if its matching. For example I have a list of drawing no's in first sheet and second sheet have the...
  7. A

    Activecell.FormulaR1C1 throws a Runtime Error '1004' in Excel VBA

    This formula was written while recording a Macro. Works perfectly fine in a cell , but when trying to run from VBE ,its throwing a runtime error '1004'. Any help appreciated .... Thanks in Advance Sub Macro7() ' ' Macro7 Macro ' ' ActiveCell.FormulaR1C1 = _...
  8. C

    Collect Tab information to create a main list

    I am working with an excel workbook(google sheet) which has about 78 tabs. Each tab has information such as contact information, location, group name, etc. With all of that information I need to compose main list. As well as to reflect any information they add or remove. I thought of using the...
  9. C

    Collect Tab information to create a main list

    I am working with an excel workbook(google sheet) which has about 78 tabs. Each tab has information such as contact information, location, group name, etc. With all of that information I need to compose main list. As well as to reflect any information they add or remove. I thought of using the...
  10. W

    Reccomendation for Countif when data contains "2018"

    I am trying to create lookup table that will return certain criteria based on annual date ranges. So I have a data validation / drop down list to change from 2018, 2017, 2016. But I'm drawing a blank how to create a CountIf based on the year within the text of the cell range. I have done this...
  11. K

    Standard notes wizard

    I would like to set up a Standard Notes wizard for our drafters. For my example, we make three different types of drawings: Assembly, Welding, and Sheet Metal. I would set up a table with notes in the rows and drawing types in the headers. <tbody> NOTE ASSY WELD SHTMTL INTERPRET DRAWING PER...
  12. S

    Angled Cell Fill

    I have an excel sheet with all cells the same size (20 pixel rows and columns). I have top borders on range C2:Z2 and F18:AJ18 and I inserted lines to connect the end points using alt key so the lines connect in the corner of the cell. For the cells that get cut by the straight line (that's on...
  13. ebea

    Math problem (excel formula)

    Hi all! Are there out in the Forum, one or other person, with good math understanding? I need some help, to find a way to calculate an outer measure (outer to outer of the bend), on a pipe which are bended 2 times, in an angle on 180 degrees on each, and to make a formula in Excel, for this! I...
  14. D

    MACRO: seek, copy and paste only the last review of a drawing

    Hi everybody! I work in a technical office for a construction firm. As you can imagine, we have an Excel file with thousands detailed drawings regarding the construction. Every drawing is associated to a code, which is made up of various parts. I avoid to explane each part of the code, the only...
  15. S

    Document Control - Duplicate Values and Corresponding Columns

    Hello, I am building a spreadsheet to keep track of construction drawings. For those that do not know, these drawings will get revised from time to time, so it is important to know which revision is the most up to date. So far what I have is a column (Column A) which has a list of drawing...
  16. Z

    vlookup with multiple instances

    I have a list of over 1000 drawings in one column and the building the drawings are associated with in another column. I have another list of drawings I am trying to match the right buildings to using a vlookup but the problem I am having some some drawings have multiple buildings associated to...
  17. A

    simpler VBA code with a loop

    Hi to all I have a piece of code that is working, but i would like to make it simpler by using a loop. could someone assist me? bellow is my code: '%%%%%%%%%%% DELETE previous pictures from the worksheets%%%%%%%%%%%%%%%% 'Approval drawing 1 Dim myObj1 Dim Pictur Set myObj1 =...
  18. pcc

    Why does object redraw every time?

    Hi all. I have written a workbook that allows me to display chords for the ukulele (I am left-handed and I cannot find a left-handed version on the internet anywhere.) In order to do this, I have created a drawing object by grouping together various lines and rectangles, to mimic the fretboard...
  19. M

    Lost sheet formatting after re-open

    Hello I closed my PC for a week. After re-opening Excel give me a message that it did found some error and re-opened it. Now, my main page is displaying only the formula. No format nor drawing is shows. All drawing was linked to a macro. I don't found the proper way to explain the problem...
  20. V

    keeping object relationship the same when expanding a userform

    I am trying to run a userform in full screen on opening a workbook then place a plan view drawing of a site at full screen and on that drawing have "hot spots" ie command buttons that carry out an action. Thats the broad brush stroke of my requirement. My issue is maintaining the relationship...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top