Retain the calculations for the extracted filtered records

[ahamedcader]

Hi, I have a workbook with three sheets. the 1st sheet has the list of records, the 2nd and 3rd sheet has calculations refering to 1st sheet.
the 1st sheet has the Application scan results belonging to different Application Owners. Is it possible to have a macro to extract the entire workbook individually for each Application Owner. In this way I can have the calculations retained for each Applcation Owner and can be distributed to the respective Application Owners. Thank you in advance for your help.

[Olly]

Please don't post duplicate threads. Have a read of The Rules

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
http://www.excelforum.com/excel-new-...d-records.html
Thread Closed.