We help IT Professionals succeed at work.
Get Started

Copy N consecutive visible rows from filtered data to another worksheet

Last Modified: 2015-03-03

I am looking for a formula that will copy a visible cell from a filtered dataset in another worksheet (see attached sample for filtered example).  

I want to create a table in another worksheet that contains cell ($A$1,1) to cell ($A$1+4,1) from the filtered data where N refers to another cell that contains which visible row to start from.

For example:
if $A$1 contains the value 3, then the first cell in the new table would contain the 3rd visible item in column 1 from the filtered data.  The second cell in the new table would contain the 4th visible item in column 1 from the filtered data, etc.

Hopefully that makes sense.
Watch Question
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE