Filtering data from 1 sheet to another Solved/Closed

Question

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 :)

TrowaD · Answer

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

mmtmacros · Answer

Cool! Thank you :)

Filtering data from 1 sheet to another

2 responses

Subscribe To Our Newsletter!