offset formula

I am in dire need and have spent hours trying to get this right... I need to pull the latest 25 data cells in a row for use in a graph. The data is set up like this starting in cell D76: "Jan-03" "Feb-03"...."Sep-10" *blank* *blank* *blank* "33.51" "36.60"...."74.71" I need to have it so...

Hi there! I'm trying to do a goal seek with an offset but i haven't written code (and even when I did only took an intro class) in 5 years! Sos I am trying to change the value in SHEET1 cell E49 equal to the VALUE in cell E436 on the same sheet ("SHEET1") by changing cell E38 on tab SHEET 2...

Hi. I've been out of practice with VBA for a few months and I can't remember how to do this... My code searches through all the used cells in column D to find a blank cell (which only occurs on subtotal rows -- the actual subtotal descriptions are in column B which is hidden) . Then I use...

I have created the below formula to return an address. I need to use this address in the second formula ("cell address here"), If i am completely off base please point me in the right direction.. =CELL("Address",INDEX($BO$23:$BO$40,MATCH($BE$4,$BO$23:$BO$40,0))) =OFFSET("Cell Address...

Hi, Hope someone can help! I'm working in a workbook with around 4 charts (mixture of line/bar/line & bar on two axis etx) each of these has more data added every week. I am trying to update these so I don't have to change the series every week I have managed to create a test workbook using...

I am currently working on a spreadsheet that uses an Offset formula to reference data from another tab in the workbook. When I copy the formula down, the formula stays exactly the same, but I need the row reference (8) to change to (9) and so forth down the spreadsheet. Below is an example of...