Hi all,

First off thanks for reading my post im hoping I can get a little help,

Im a beginner when it comes to Excel, escpecially the macro and programming side, my problem is this, (please be patient ill try my best to explain demonstrate)

I recieve a .xls from work it contains 2 worksheets with numerous amounts of data, Ive developed a way to edit the data into a nice presentation in thier respective worksheets, and im able to add a filter to each worksheet dependant on an employee name, is it possible to create a 3rd sheet which when sheet 1 + 2 are filtered it will merge the 2 sets of filtered data in the 3rd sheet while in the same workbook? and do the same for each employee as and when you filter there name on sheet 1 + 2? (also showing the the other data corresponding to the employee)

Thanks so much to anyone reading or offering advice ideas ^^

Cheers

Sando

Note: I edited the .xls I recieve and save it for redistribution so is this possible to add as a macro or something after I complete my editing process befor re saving? so the people recieving can use the function?