Acronym Macro

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


I am trying to create a Macro linked to an Excel button from the forms
toolbar in cell N1 of *** 1. I would like it to perform the following
steps.

1. Copy the entire contents of rows in *** 1 from A2 to L30.

2. Sort all the contents of rows A through L based on the acronyms AAAA,
BBBB, CCCC, DDDD, & EEEE and group the AAAA with the AAAA, the BBBB with the
BBBB, and so on. (The acronyms are located in Column F rows F2 through F30).

3. Create and name a new work*** for all the AAAA, BBBB, CCCC, DDDD, &
EEEE.

4. Paste all the contents of rows A through L containing AAAA in ***
AAAA, all the contents of the rows A through L containing BBBB in *** BBBB,
all the contents of rows A through L containing CCCC in *** CCCC, and so
on.
Do you have any ideas about how I might make that happen?

.

Quantcast