willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- Office Version
- 365
- Platform
- Windows
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
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