wall

  1. L

    Converting data from matrix to list format

    Hi Everyone, Firstly, this forum is really great. I generally do my utmost not to post a new thread and read through other materials and try to work it out when I can. Here are some pre-existing materials on this topic that I already read through...
  2. G

    Optimize VBA copy/paste

    Hey guys, I am basically trying to make my code run faster, I am trying to convert a section of the code that copies and pastes data across two workbooks to be faster and cleaner. Here is the original paste/copy data: Sub WALLCERTIFICATE()' ' Macro2 Macro ' Dim M As Workbook Set M =...
  3. Y

    Vlookup with multiple coloums and criteria

    I have set up a table with 5 columns such as below; <tbody> DIAMETER WALL Low Ø HI Ø LO HI OD ± 0.000 12.740 0.510 1.240 0.100 12.700 25.400 0.510 1.650 0.130 12.700 25.400 1.660 3.400 0.250 25.400 38.100 0.640 1.650 0.200 25.400 38.100 1.660 3.400 0.250 38.100 50.800 0.640...
  4. M

    VBA form data to specific cells

    Hi, I'm new to forms and a beginner on VBA, so struggling with a VBA to make a user form fill in specific cells in a sheet. I have created the form and now I want to get the data from the fields into the cells on the worksheet and if the cells in the worksheet have data in them for this to be...
  5. U

    How to Increment a Alphanumeric String on Number of occurrences in Column

    Hello All, I have this code very close to what I need it to do but I think I need to add a counter of some sort. I'll try to explain this AS BEST AS POSSIBLE. I need this code to count how many times there is an occurrence of an Alphanumeric value in Column C and then simply increment the...
  6. C

    Cells not returning a value - when i know the formula is correct!!!

    I have this formula that is working in several other programmes that I have made, that are identical in nature. However, this one programme fails to return the value of my concatenation. The cell returns no errors. I have set the formulas to update automatically. I do believe this is an easy...
  7. R

    Data Validation list with condition

    Hi , I have two columns and have values like: Location Fixture Garage wall Front Porch Fixture ******* wall Lobby None Now i need to get the list of those location which fixture <> None Can I get help please?
  8. M

    Finding the sum of items across multiple rows and values

    I'm trying to figure out what combination of sumproduct to use to get the quantity total from the 'Inventory' sheet to the 'Weekly Report'. I'm hitting a wall since Inventory lists multiple of the same style while the Weekly Report has just one for the total. Any help would be appreciated...
  9. N

    Moving form button anywhere on chart?

    Hello, So I have chart that is displayed in it's own tab, and a row of form buttons were placed along the x-axis (by another user). When I move one or more of the form buttons, I find that there is an invisible "wall" approximately 3/4 of the way across the chart. For example, I can drag a...
  10. J

    Creating Chart

    I am trying to draw walls in a building that the user inputs. The only way I can think to do this is with a scatter plot with each wall being its own series so that each wall can have its own trendline and data label. For now, the user can input 125 walls. I'd rather not take the time to...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top