Macros

[Mully]

Hi
Perhaps not explained very well, re wrote macro as
suggested works ok however on duplicating a name the
constant figures do not enter cells. for example -

A2 = A. SHAW.B2 = 195.C2 = 1054
A3 = M. HALL.B3 = 194.C3 = 21
ABOVE ALL OK

(CELL A40 ENTERED A. SHAW) CELLS B40 & C40 REMAIN BLANK.IS
IT POSSIBLE WITHIN THE MACRO FOR THE CONSTANT FIGURES AS
IN B2 AND C2 TO BE AUTOMATICALLY ENTERED WHEN ENTERING A
NAME IN A40 OFF THE TABLE. IS IT ALSO POSSIBLE WHEN THE
LIST IS COMPLETE FOR IT TO AUTOMATICALLY TRANSFER ITS SELF
TO ANOTHER SHEET WITHIN THE WORKBOOK. WHAT WOULD I HAVE TO
DO IF A NAME WAS IN THE LIST AND FOR CERTAIN WEEKS OF THE
YEAR HE/SHE WOULD BE ON HOLIDAY AND HIS/HER NAME WOULD
NOT BE NEEDED ON THE LIST. SORRY ABOUT THE QUESTIONS AND
LONG EXPLANATIONS I'M JUST A NOVICE TRYING TO SPEED THINGS
UP FOR MY COMPANY.

MANY THANKS AND APPRECIATION FOR YOUR TIME AND EFFORTS.

REGARDS

MULLY

-----Original Message-----
Selections are NOT necessary OR desirable

Range ("A2")= "A.SHAW"
Range ("A3")= "M.HALL"
Range ("B2")= 195
Range ("C2")=1054
Range ("B3")= 194
Range ("C3")= 21

range("a42:a49")="whatever"
range("a42,a45,a48")=1


--
Don Guillett
SalesAid Software
(e-mail address removed)



.

..