My reference data is in another worksheet (I'll call it Sheet2) and occurs evey eighth row in the same column (e.g. N30, N38, N46, etc). I want to write a formula in my current worksheet (Sheet1) where I can then drag/fill it down the column and each row (A1,A2,A3,....) will reference every eighth row in my reference worksheet (Sheet2). I've read some similar posts about using INDIRECT, OFFSET, etc but I can't seem to get it to work. It seems like this shouldn't be so difficult. Very frustrated so hopefully someone can help me out here. Thanks
Bookmarks