wall

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...

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 =...

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...

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...

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...

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...

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?

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...

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...

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...