Dear Sir/Madam, in the attached spreadsheet, I have a Macro that was designed that is not running exactly the way I need it be run. The Macro copies data from one tab, based upon a value, into the corresponding tabs. In the attached spreadsheet, on the "EE Help Needed" tab, I have explained what is going on and what I need it to do. I have also copied the Macro code into a Word document since I recall when I load the spreadsheet the Macro code does not load up with it. Thank you very much for your time and expertise! James.