uttamsaxena
Board Regular
- Joined
- Apr 22, 2003
- Messages
- 182
For keeping record of provient fund, I have made a excel database in a sheet with many fields like ID, Name,contribution for months eg March, April,..to..,Feb,etc.It contains 500 records.
Now I have to print the provident fund statements of my 500 friends. This statement consists of some text language and some data.The statement also shows some data which has to be calculated from the data of database eg grand total, cumulative total, interests etc.
Now I want to print the statement for all or selected no of people. What I want is to make the statement proforma in another excel sheet and then merge and print the statements for selected no of persons eg for ID 1 to 20, 50 to 70 etc. I do not want to make statement in MS word and do not want to merge it there, but I want to do it in excel just as we do in MS word mail merge.
Pl help me how can I do it in Excel?
Now I have to print the provident fund statements of my 500 friends. This statement consists of some text language and some data.The statement also shows some data which has to be calculated from the data of database eg grand total, cumulative total, interests etc.
Now I want to print the statement for all or selected no of people. What I want is to make the statement proforma in another excel sheet and then merge and print the statements for selected no of persons eg for ID 1 to 20, 50 to 70 etc. I do not want to make statement in MS word and do not want to merge it there, but I want to do it in excel just as we do in MS word mail merge.
Pl help me how can I do it in Excel?
