Byron_One
02-07-2016, 02:44 AM
Hi everyone
I am new to VBA and could really do with some help with something.
i have a workbook called Sales.xls which contains 7 worksheets called North, East, West, South, North West, South East and North East. Each sheet contains Sales by region of the area. What I need to do is create some code that looks at the North, East, South and West sheets only and looks at the column Location in these sheets to see if there are any records (rows) containing the value ZZZ (this is an erroneous value). If it finds any of these records then I'd like all of these rows to be copied to a new sheet in the workbook called ZZZ.
Any help would be much appreciated.
BO
I am new to VBA and could really do with some help with something.
i have a workbook called Sales.xls which contains 7 worksheets called North, East, West, South, North West, South East and North East. Each sheet contains Sales by region of the area. What I need to do is create some code that looks at the North, East, South and West sheets only and looks at the column Location in these sheets to see if there are any records (rows) containing the value ZZZ (this is an erroneous value). If it finds any of these records then I'd like all of these rows to be copied to a new sheet in the workbook called ZZZ.
Any help would be much appreciated.
BO