j19_2002
02-18-2011, 01:39 PM
Hello All,
I have spent the last hour searching for possible solutions to my problem on the forums, but nothing has worked yet so hopefully someone can help me out.
What I need to have happen is sort sheets CBTX all the way to NYB
From B10 across to J10 and all the way down if there are multiple entries.
Sometimes there are no entries in certain sheets but others may have up to 40 or 50. I need it to sort by Branch # Ascending on all the sheets.
I tried recording a macro but came up with a problem when there is no entry and it just cut off.
Please Help!! Thanks
P.S. I have attached a sample worksheet of what I use.
I have spent the last hour searching for possible solutions to my problem on the forums, but nothing has worked yet so hopefully someone can help me out.
What I need to have happen is sort sheets CBTX all the way to NYB
From B10 across to J10 and all the way down if there are multiple entries.
Sometimes there are no entries in certain sheets but others may have up to 40 or 50. I need it to sort by Branch # Ascending on all the sheets.
I tried recording a macro but came up with a problem when there is no entry and it just cut off.
Please Help!! Thanks
P.S. I have attached a sample worksheet of what I use.