Filtering data from 1 sheet to another [Solved/Closed]

Report
Posts
2
Registration date
Thursday April 17, 2014
Status
Member
Last seen
April 17, 2014
-
 mmtmacros -
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

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Cool! Thank you :)