I need a macro that will select rows based on values in Column A from multiple sheets and create a new workbook for each value with matching sheets with only matching values data populating these sheets. Example: All values from column A that equal "value 6" would have those rows copied from each sheet (sheet 1, sheet 2, sheet 3 etc.)and a new workbook would be created with matching sheet names (sheet 1, sheet 2, sheet 3 etc.) and data from each sheet would be pasted in matching sheet. So the newly created workbook would have only value 6's data included. Workbook 6 (Value 6 data) etc. I've attempted to explain this as clearly as possible. I've attached a workbook as an example. Thank you in advance for any help.
Bookmarks