M
Montu
Wish you a Happy New Year
I have to maintain our representative database & send it to our head office
lilke
A B C D
E F
1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id
Send Date
2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312
12/11/2007
3. 2 12/11/2007 GHJBN5826L U.K.Ghosh 0256
13/11/2007
4. 3 13/11/2007 HTYVD7475K S.N.Bose 0312
13/11/2007
continued to end of data.
Now I have to keep month-wise record according Rep. & type a letter (List of
document) when send the document to our head office. Now I f want solution of
two problem -
1) Sl No. will be continue if Rep. Id is same. example as below -
A B C D
E F
1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id
Send Date
2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312
12/11/2007
3. 1 12/11/2007 GHJBN5826L U.K.Ghosh 0256
13/11/2007
4. 2 13/11/2007 HTYVD7475K S.N.Bose 0312
13/11/2007
2) Document list (PAN No) automatically copy from database to letter by
matching letter date with send date, I have designed in excel sheet to
write a letter for send document to our head office like
------------------------------------------------------------------------------------------------
Date : 13/11/2007
To,
The Manager .....
Dear Sir,
I'm sending some receiving documents whose PAN No as follows -
GHJBN5826L,HTYVD7475K .......
Total no. of document .....
Thank you.
I have to maintain our representative database & send it to our head office
lilke
A B C D
E F
1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id
Send Date
2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312
12/11/2007
3. 2 12/11/2007 GHJBN5826L U.K.Ghosh 0256
13/11/2007
4. 3 13/11/2007 HTYVD7475K S.N.Bose 0312
13/11/2007
continued to end of data.
Now I have to keep month-wise record according Rep. & type a letter (List of
document) when send the document to our head office. Now I f want solution of
two problem -
1) Sl No. will be continue if Rep. Id is same. example as below -
A B C D
E F
1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id
Send Date
2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312
12/11/2007
3. 1 12/11/2007 GHJBN5826L U.K.Ghosh 0256
13/11/2007
4. 2 13/11/2007 HTYVD7475K S.N.Bose 0312
13/11/2007
2) Document list (PAN No) automatically copy from database to letter by
matching letter date with send date, I have designed in excel sheet to
write a letter for send document to our head office like
------------------------------------------------------------------------------------------------
Date : 13/11/2007
To,
The Manager .....
Dear Sir,
I'm sending some receiving documents whose PAN No as follows -
GHJBN5826L,HTYVD7475K .......
Total no. of document .....
Thank you.