Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-22-2022, 05:37 PM
sagar sagar is offline Need VBA file for automatic selection of sorted data Windows XP Need VBA file for automatic selection of sorted data Office 2021
Novice
Need VBA file for automatic selection of sorted data
 
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, 11 views)
File Type: png 2.png (19.2 KB, 11 views)
File Type: png 3.png (23.8 KB, 11 views)
File Type: png 4.png (6.5 KB, 11 views)
Reply With Quote
 

Tags
excel 2007 formula, macro, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting data from a column into another but sorted and with 2 related cells next to it Ricko_uk Excel 2 08-24-2020 02:48 PM
Automatic slides selection Vinh8888 PowerPoint 1 06-29-2018 01:31 AM
How do I insert a file of sorted photos and retain that order? uncledewey PowerPoint 0 09-03-2017 02:07 PM
Need VBA file for automatic selection of sorted data Lookup a value from non-sorted data udea Excel 12 04-25-2011 04:34 AM
Automatic find replace after selection in dropdown vsempoux Word 0 10-28-2009 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft