Here is what I wish to eventually achieve, and would be
grateful for some help with the first part:

User chooses a workbook, and in each sheet in col G
they will 'mark' any row they choose with a value from
A to Z (Later they will be able to do the same in cols
H and I).

I'm going to sort and group in sheets in a new workbook
based on the values in col G only (for now), such that
all the rows marked 'A' end up in sheet 'A' in the new book
etc.

So ideally the code would run, then pause to allow the
user to enter their 'A', 'B's etc after which the code
would present a form (ideally) containing the unique
values in col G against which the user could input the
'true' name (say 'A' represented Timber), such that
a new sheet could be named "Timber" where all
'A's could then be placed.

If that makes sense, then how best to pause the code,
and what is the best control for the form, please?
Or is there a better way?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003