Filtering data from 1 sheet to another

Solved/Closed
mmtmacros
Posts
2
Registration date
Thursday April 17, 2014
Status
Member
Last seen
April 17, 2014
- Apr 17, 2014 at 08:06 AM
 mmtmacros - Apr 24, 2014 at 02:26 AM
Hello,

I have the following problem. Kindly help me with the same:

Problem statement: I have data pertaining to projects, milestones and tasks in sheet1. I want this data to be filtered on the basis of milestones and copies to sheet 2 automatically, such that as soon as I add data in sheet1, sheet2 should also get populated.

Your help is much appreciated. Thank you :)

2 replies

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Apr 22, 2014 at 12:01 PM
Hi mmtmacros,

Try this.

Start recording macro.
Apply autofilter.
Filter data as you see fit.
Select all cells and copy.
Go to next sheet, select all cells and paste.
Remove autofilter.
Stop recording macro.

Now apply shortcut key to macro.

Hit shortcut whenever you want to update sheet2.


Or right-click sheet2's tab and select view code.
Near the top are 2 dropdown lists. Choose Worksheet and Activate.
Now copy the recorded macro (Without the first and last line) and paste it between the 2 code lines to run the code whenever you activate/look at sheet2.

Best regards,
Trowa
1
Cool! Thank you :)
0