Filtering data from 1 sheet to another

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

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
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,
Cool! Thank you :)