Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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, 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
  #2  
Old 11-23-2022, 12:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need VBA file for automatic selection of sorted data Windows 10 Need VBA file for automatic selection of sorted data Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi why are you posting in a non-VBA subforum?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
excel 2007 formula, macro, vba

Thread Tools
Display Modes


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 07:48 AM.


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