VBA - How to Select/Copy first 12 Visible cells on filtered data (minus header A1)

[willow1985]

Hello

I have googled this question but have yet to find something that works and seem to be having an off day...

I have a table called "DATA" and what I am looking for is a VBA code that will select the first 12 cells in column A (minus the header in A1), copy those visible cells and paste them into 2 separate spreadsheets.

How would I go about selecting the first 12 visible cells in column A on a filtered table?

Thank you to anyone who can help

Carla

 

[willow1985]

Then that would select A2 even if it is hidden.

I have decided to go with the most recent code I posted and just accept the header and up my selection to 13.
I was hoping there was an easier solution but the Dim looper As Integer code I found seems to be doing what I need with the exception of it grabbing the reference point.

Thank you for your help

 

[Norie]

Carla

Are you sure your code will only copying the first 12 filtered values?

 

[willow1985]

Carla

Are you sure your code will only copying the first 12 filtered values?

It appears to be working