Currently i am working in a excel workbook that should fetch information from another work book (shared) and generate report in a specified format required by me regularly when i was clicking the generate report tab. can u help me sending some model vba code or the way i should perform the process