I have 4 different master files and all files contains pivot with Account Names and code that copies data from pivots and pastes in Temp file. If Account Name is missing in any master file, it gives error. I want, if Account Name is missing in any master file VB code should skip that master file and pastes data in Temp file where Account name is found. Is it possible, TIA