Avatar of BOULMAN
BOULMAN
 asked on

Using user defined to copy values to another sheet

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
Microsoft ExcelSpreadsheets

Avatar of undefined
Last Comment
BOULMAN

8/22/2022 - Mon
Saqib Husain

You forgot to attach the spreadsheet
BOULMAN

ASKER
Sorry about that.
Copy-of-PolsoxExperiment.xlsm
ASKER CERTIFIED SOLUTION
Saqib Husain

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
BOULMAN

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

thanks
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
BOULMAN

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

ASKER
Fast and simple.  Thank you!!