i HAVE SHEET LIKE THIS FILE NAME AS ADVANCE FILE


NAME JAN FEB MAR APR JUN JUL AUG ...............

JOHN 100 200 300 400 200 200 200
KATE 200 200 200 200 200 200 200
LAURAL 200 200 300 300 300 300 300

IN PAY ROLL FILE I WANT TO DEDUCT THE ADVANCES

MY SYSTEM SHOULD TAKE AUTOMATICALLY THE VALUES IF I TYPE JAN IT SHOULD TAKE
JAN VALUES AGAINST JOHN, KATE AND LAURAL IF FEB, FEB VALUES AND MAR, MARCH
VALUES.......... ETC

CAN ANY ONE HELP ME IN THIS ........PLEASE


SRINIVAS




--
srinivas