dynamic cell range

Hi all, As with the screenshots below I am struggling (in my head) to figure out a way to turn my 'Product!$AK$31:$IQ$31>0' & 'Product!$AK$29:$IQ$29' into a dynamic range (PIC1) i.e. I want to be able to insert a Match formula to reference cell AE57 - 'Panel_1' & "Product Description" which...

Hello all, I'm working on a userform and am setting up some insurance the users enter the required data. I have a three text boxes: tbMaterial, tbQty and tbCost. There is a index match function for tbMaterials that fills in the cost if its a material we already have the price for. If we do not...

Hi guys, I've made a PP presentation with numerous charts. To make the monthly updates run smoothly, I've created dynamic references to the input vectors of these charts - you know, offset(,,,,counta()) and so forth. Then I paste the charts to PP, choosing the 'link data' option and everything...

After many hours it is time to ask for help! I have a blank sheet which I paste extracted data to with VBA. Columns A:E are static but the rows vary. The code loops and pastes data set at 5 rows from previous data until end. So I have blocks of data with space of 5 rows inbetween. I want to...

I've found various topics about this, but I just can't seem to get mine to work. Here is my formula: =SUMIFS(INDEX('[FY16 ForecastMaster.xlsm]Orders'!$B:$NW, 0, MATCH(DateMatrix!$F$1, '[FY16 ForecastMaster.xlsm]Orders'!$B$2:$NW$2,0)), '[FY16 ForecastMaster.xlsm]Orders'!$B$2:$B$357, Sheet1!B2)...

I am trying to make a chart that will change based on the active cell's row. This workbook will be used exclusively on iPads for field work. As far as I know the ios version of excel does not support macros so I will have to make this chart without using macros. I've figured out how to do it...

I want to automate a spreadsheet data such that: 1. I cut and paste into first sheet some date 2. The second sheet has formulas that execute on the dataset in the first sheet. The problem I have is that I want to refer to columns in the first sheet without providing a start and finish range...