Copy to sheet name in column 1
Hi Howard,
Am Sun, 25 Oct 2015 17:30:29 -0700 (PDT) schrieb L. Howard:
Trying to copy AREAs to the sheet of the employee whose name is the same as "Ar" in the - For Each Ar In Columns("A").SpecialCells(xlConstants).Areas
If current Ar = Name 1 then the AREA should go to the sheet named Name 1.
I'm using Name 1, Name 2 etc, as sheet names and employee names.
"Main" sheet column 1 has Name n and data for Name n is in columns B to E down any number of rows. Say 5 to 45, varies.
There is a one blank row between AREAs.
can you send me an example workbook?
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|