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.
Start recording macro.
Filter data as you see fit.
Select all cells and copy.
Go to next sheet, select all cells and paste.
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.