How to make my formula increase the row reference by 8?

[mcgeesusana]

Hello,
I need to be able to pull information from multiple cells from sheet1 to sheet2. In sheet 2 I am creating a horizontal log of these specific cells in Sheet1 that I need. Although the pattern repeats every 8 rows, I can't use this formula =OFFSET('Appraiser Name'!$G$1,(ROW()-1)*8,0) for every cell because this will work only for some of them that are to start with on row 8 counting from the first row in Sheet1, I need help because I can't do this manually because when I finish I will have 700 rows on the log in sheet 2. Can you help me? Thanks

 

[Joe4]

I am not quite clear why you cannot use your OFFSET formula. I am not sure what you are saying there.
Perhaps it would be more helpful to show us a small sample of your data and your desired result.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.