Firstly let me highlight a slight problem that might need correcting before we can being......At present if the user click the "Delete Supplier" macro button on worksheet "Deal Selecton" IT HANGS....this is because it is step up to look for a corresponding worksheet.
So if i was to delete Repsol then > it would also delete the worksheet Repsol.....if there is no worksheet of that name present in the workbook IT HANGS........
1. So is it possible to delete what ever supplier name the user selects (worksheet "Deal Selection" column B) irrespective or not a worksheet of that name is in the workbook.....if the workbook is present then also delete it too.
2. KNOW if i delete a supplier name from column B worksheet "Deal Selection" then >
I also want to remove from the following worksheets (Allocaction (base) + (Vol) +(Sc.1) + (Sc.2) and (Sc.3) - for agrument shake
Say i was to delete Repsol from Column B then > also delete from the above mentioned worksheet Repol from column B:E in worksheets (Allocaction (base) + (Vol) +(Sc.1) + (Sc.2) and (Sc.3)........
See highlight data as a guide.......
Thi question is also posted on link: http://www.experts-exchange.com/Soft..._23407697.html