Hi
I am new to writing macros and am trying to learn it along the way.
I needed help on a task where I am trying to write a macro for.
I have 2 columns and data in both in sheet 1. I need a macro to
1) sort data in column 1 alphabetically with its respective data into column 2
2) i then need to find a text range for the sorted data and have those rows along with their columns copied into a sheet 2.
for example, post sorting in sheet 1, i need
all words starting with letters A, B, C, D and E are copied to sheet 2
all words starting with letters F, G, H, I, J go to sheet 3
all words starting with letters K, L, M, N, O go to sheet 4
all words starting with letters P, Q, R, S, T go to sheet 5
all words starting with letters U, V, W, X, Y, Z go to sheet 6
all words starting with numbers go to sheet 7
Thanks
Steve
Bookmarks