Cell function to advance from nth cell in another sheet

[davedmw7]

I apologize if this is posted somewhere else but I could not find what I was looking for.

· I am creating a table on one sheet (‘Sheet’) that pulls values from another sheet (‘Sheet1’).
· Sheet 1 contains all of my data.
· However, I do not need all of the data in the table.
· I know that I only need the tenth row of data for each column.
· I want to simply copy a function from one cell to the next that will allow me to pull values from every tenth cell on the next sheet.

Is there a way to do this? I hope the illustration helps; please let me know if you have any questions. Thank you for any help.

I am running Excel 2010 on Windows 7 Professional.

Dave

	Actual Cell	Cell "Function"
Data1	='Sheet1'!B1	='Sheet1'!B1
Data2	='Sheet1'!B11	='Sheet1'!B1(+10)
Data3	='Sheet1'!B21	='Sheet1'!B11(+10)
Data4	='Sheet1'!B31	='Sheet1'!B21(+10)
Data5	='Sheet1'!B41	='Sheet1'!B31(+10)

<tbody>
</tbody>

 

[Jonmo1]

Cross posted
Cell Function to Grab Data from the nth cell on another sheet

Did you try the suggestion on the other site?

 

[davedmw7]

Thanks. Are these essentially the same site?

 

[Jonmo1]

I guess, if you consider ESPN.Com and CBSsports.com the same as well....

 

[davedmw7]

Haha. Point taken