Excel Row Increment
Posted on 2013-01-23
I have an Excel workbook with 2 sheets "A" and "B". I have multiple pieces of data to pull out and I need to figure out how to increment the Rows and grab the data from SheetA to SheetB and then drag that formula down X amount of rows.
For example I want to pull data from the initial CELL G2 and then every 92 rows after that so G2, G94, G186, Etc... and this happens for hundreds of rows so I don't want to do this manually.
I would appreciate any help.