Using user defined to copy values to another sheet

BOULMAN
BOULMAN used Ask the Experts™
on
We have a data extract that has hundreds of values in it.  We need to only pull some of the values, say every 60 rows.  For example if the user wants to start the coping at row 10 but only pull every 60 after that.  Is there a way to do that?
Attached is a copy of the spreadsheet

thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Saqib Husain, SyedEngineer

Commented:
You forgot to attach the spreadsheet
BOULMAN

Author

Commented:
Sorry about that.
Copy-of-PolsoxExperiment.xlsm
Engineer
Commented:
Use this formula in F2 and copy down

=INDEX(B:B,(ROW()-2)*60+$E$2)

****EDITED****
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Learn More!
BOULMAN

Author

Commented:
That works perfect for the first value.  But how do I get it to add 60 for the next value?

thanks
BOULMAN

Author

Commented:
I am sorry it does work.  Thank you so much!!!
BOULMAN

Author

Commented:
Fast and simple.  Thank you!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial