Automatically Copy and Past a Variable Number of Cells Based on a Cell Reference

Hello!

I have data in columns ID number, name, and email on one page. I want to have a separate page where a user can type the number of people they want on their list into a cell, then click a button which automatically copies the info for that many people into another page, generating a list of whatever size they choose.

Does anybody know how to do that? Is there a way I can do it by a formula? Or is it 100% a macro I have to code (I don't know how to do that).\

Thanks so much for your help!!

Joe

I would wait until you hear from another more experienced member, but I cannot think of any way to do this without using macros.

Steve