View Single Post
Old 11-22-2022, 05:37 PM
sagar sagar is offline Windows XP Office 2021
Join Date: Nov 2022
Posts: 1
sagar is on a distinguished road
Default Need VBA file for automatic selection of sorted data

I would like to create a macro for automatic selection of the filtered data. Please help me with VBA code.

The steps for selecting the data:

1) I sorted raw data
2) From that filtered data, I am selecting only 3 columns (Column 1st, 3rd, 5th)
3) Selecting 3 columns for making a copy-paste
After performing any filtering/sorting, I need to select the data from the specific three columns.
Please see below pics, I would like to select only orange columns
Attached Images
File Type: png 1.png (35.4 KB, 8 views)
File Type: png 2.png (19.2 KB, 8 views)
File Type: png 3.png (23.8 KB, 8 views)
File Type: png 4.png (6.5 KB, 8 views)
Reply With Quote