panels

I am such a VBA noob. ML.Activate Do Until Cells(ActiveCell.Row, "A") = "" tnam = Cells(ActiveCell.Row, "H").Value tno = Cells(ActiveCell.Row, "A").Value pup = Cells(ActiveCell.Row, "G").Value pp.Activate Range("A3").Activate Do Until Cells(ActiveCell.Row...

Good afternoon all, This flawless formula I discovered on ExcelJet is now giving me a bit of grief after months of working in various applications. Here's my code: =IFERROR(INDEX(LEFT('[Price Panels 2019.xlsm]All Tours'!$A:$A,6),MATCH(1,(A3<>'[Price Panels 2019.xlsm]All...

This is the Index Match with multiple criteria I'm using; {=INDEX(range1,MATCH(1,(A1=range2)*(B1=range3),0))} So two criteria. For the first criteria it's going to be a lookup value to range match, so like "Cotswold Adventure" will match with "Cotswold Adventure" For the second criteria...

Having problems wrapping my head around this one. so my plan is to have a table that will have DATE EMPLOYEE PROJECT# QTY for any day i would have 12 or so employees building panels, some building panels for 2 or 3 projects in a day. what I need to be able to do is total the data by...

Im trying to create a chart that has 2 different data types? Along the bottom axis is Time e.g. Week 1, Week 2, Week 3 ect. and along the left side axis I have the number of panels built This works great as a line chart and usually have between 350 to 600 panels built each week. What I...

Hello, I am hoping someone has some experience taking dimensions and converting them into decimal format. I have made some code to extract all panels from a list and create a new sheet called "Panels." I need to take this one step further, and convert the # x # format into a decimal number...