I have a chart In Column AZ there are a range of texts ("Sort 1", "Sort 2", "Sort 3") These range can go up to about Sort 40. There can be as little as 1 row in each Sort and as much as 60 rows. I wish to copy all rows in a the range (BA:BD) into another worksheet ie worksheet ("Sort 1") Range...