Hi,

I have two files in Sharedrive:
a) ABC Raw Data
b) XYZ Report

From ABC Raw data, values are picked up (using lookup function) into report and then, the entire report is copied to Desktop (leaving original XYZ Report onto sharedrive) and the same report including all tabs is converted into Values format (using paste special value) before sending it to client.

Please help me with a standard macro for this and I will (possibly) amend it according to my needs.

Thanks in advance...