Get instant live Excel expert help with ROW Functions

Enter references to the base cost and total cost in the appropriate cells on row 5

Hi there, so the other day a very nice chap helped me with the attached report generation. I may of over complicated matters by asking for the report row to start a new "row" at drop 11. I have reviewed this and it makes thing very complicated. please could someone or same chap look into simplifying the code so it just produces the individual routes, each route to be 1 row not separated at drop 11. I have issued more notes in tab (introduction). The range of deliveries varies from day to day so a dynamic range is needed in all formulas on sheet1. It would also be great to if the consolidation i have tried adapting works prior to the report generating. this needs to consolidate like deliveries of that route group and summizing the volumes K and J into the first match of that duplicated delivery location. I understand i am asking alot i am willing to pay for repeat sessions. your help in simplifying and explaining the script that generates the report would be very much appreciated. or looking into the consolidation. it up to you. cheers and kind regards Currently some formula are not working due to the requirement of dynamic range

Hi there, the other day a very nice chap helped me with the attached report generation. I may of over complicated matters by asking for the report row to start a new "row" at drop 11. I have reviewed this and it makes things overly complicated. please could you add in simplifying the code so it just produces the individual routes, each route to be 1 row not separated at drop 11. I have issued more notes in tab (introduction). The range of deliveries varies from day to day so a dynamic range is needed in all formulas on sheet1. I understand i am asking alot i am willing to pay for repeat sessions. your help in simplifying and explaining the script that generates the report would be very much appreciated. or looking into the consolidation. it up to you. cheers and kind regards Currently some formula are not working due to the requirement of dynamic range

My dependent data validation formula works only for the first row. the formula I'm using is: =OFFSET(Heading Cell, MATCH(cell, picklist range,0),0, COUNTIF(picklist range, cell))

I want to create a VBA loop that moves row by row, from H4:Q4 to H23:Q23, and ADDS the values in cells H186:Q186 to H205:Q205. I want it to run this loop until certain conditions are met in the table containing cells B3:E24.

I am trying to reference a specific location in Tab A to use in a formula in Tab B. That location is "second one from the left in row two." This is different from saying B2, because B2 or $B2 will still shift if a new Column B is inserted and will become C3 or $C3. I am trying to get info from the *same location* whether or not additional Columns are added. How?

I need formula to track a call schedule. The column header are dates and the row headers are the type of calls; everything else is filled with initials. I want to be able to tally everything on a separate worksheet where i listed all the names as row headers and the different types of call as column headers.

I'm having a problem with cell AH237 on the "Design CTR". It is meant to show an average % for all tasks which have started in accordance to the start date; however if highlight the cells within row AH between cells 137:236 for only the cells greater than 0 it gives you a result of 93%. This value is what I would expect to see in AH237 but it's showing 100%. The formula seems to work in the sections above, i.e. cells AH113 or AH91 or AH69

Tabs to Look at: Oboe OboeFormResponses Need to get Column D starting at Row 26 to return data in Row C of the OboeFormResponses tab. Currently it returns the data is Column C of the Oboe tab.

I need to pull the value of a cell in another document. The cell will have a column number O and a row number that is determined by the column C