This is my second thread and I hope someone would be willing to assist a novice VBA programmer (although I'm not sure I even qualify as a novice). Here's the situation... I have a worksheet named "Master Matrix". I want to copy items from the worksheet (called "Master Matrix") based on certain criteria. All items are broken into zones (i.e. A Zone, B Zone, etc.) and I need a Macro that can (1) Look to see if a sheet has been created for the criteria in question (in this case look for a worksheet named "A Zone"), (2) if no sheet exists, create the worksheet and name it accordingly (in this case "A Zone"). (3) Next it has to identify which zone each item is in based on the criteria in Column AG (as you may have guessed, Column AG is named "Zones"), and copy items that meet the criteria into the worksheet named same (e.g. "A Zone" items copied to worksheet "A Zone"). If at all possible, please insert comments into the Macro so I may know which portion does what function (I may have to change this in the future). Some more specifics... the workbook is about 10,000 rows, and has Columns "A" through "AI" (... just in case that will affect your programming). It currently has Autofilter enabled. I am thankful in advance of any assistance that can be provided.
Bookmarks