avisoft20
Board Regular
- Joined
- Sep 10, 2016
- Messages
- 63
Hello Everyone Namaste,
I have a problem in Excel Data Base.I hope you will help me.Table given below :
For Example : Master Data Base.Xls
<tbody>
</tbody>
In this table i have multiple state on Sheet 1.but i want each state have separate workbook also workbook will be rename with their state name.kindly tell me how can i make separate work book .I have big data base.
And ans will be :First Workbook name will Delhi.xls
<tbody>
</tbody>
Second Workbook name will Haryana.xls
<tbody>
</tbody>
--------------------------------------------------
Third Workbook name will Punjab.xls
<tbody>
</tbody>
------------------------------------------------------------------------------------
Fourth Workbook name will Uttar Pradesh.xls
<tbody>
</tbody>
Thanks & Regards
Avinash Kumar Singh
I have a problem in Excel Data Base.I hope you will help me.Table given below :
For Example : Master Data Base.Xls
Code | Name | Designation | State |
2001 | Ankuush | A.S.E | Haryana |
2001 | Shiv | A.S.E | Haryana |
2001 | Ramesh | A.S.S | Uttar Pradeh |
2001 | Rama | A.S.S | Punjab |
2002 | Shyama | A.S.E | Punjab |
2002 | Chander | A.S.E | Punjab |
2002 | Mander | A.S.M | Uttar Pradeh |
2002 | Kundan | A.S.S | Haryana |
2009 | Rana | A.S.O | Haryana |
2009 | Rane | A.S.O | Uttar Pradeh |
2009 | Rakesh | A.S.S | Delhi |
2009 | Rajesh | A.S.M | Haryana |
2013 | Ritika | A.S.M | Delhi |
2013 | Ruchika | A.S.O | Uttar Pradeh |
2013 | Rani | A.S.O | Delhi |
2013 | Chandani | A.S.S | Delhi |
2013 | Mannu | A.S.M | Punjab |
<tbody>
</tbody>
In this table i have multiple state on Sheet 1.but i want each state have separate workbook also workbook will be rename with their state name.kindly tell me how can i make separate work book .I have big data base.
And ans will be :First Workbook name will Delhi.xls
Code | Name | Designation | State |
2009 | Rakesh | A.S.S | Delhi |
2013 | Ritika | A.S.M | Delhi |
2013 | Rani | A.S.O | Delhi |
2013 | Chandani | A.S.S | Delhi |
<tbody>
</tbody>
Second Workbook name will Haryana.xls
Code | Name | Designation | State |
2001 | Ankuush | A.S.E | Haryana |
2001 | Shiv | A.S.E | Haryana |
2002 | Kundan | A.S.S | Haryana |
2009 | Rana | A.S.O | Haryana |
2009 | Rajesh | A.S.M | Haryana |
<tbody>
</tbody>
--------------------------------------------------
Third Workbook name will Punjab.xls
Code | Name | Designation | State |
2001 | Rama | A.S.S | Punjab |
2002 | Shyama | A.S.E | Punjab |
2002 | Chander | A.S.E | Punjab |
2013 | Mannu | A.S.M | Punjab |
<tbody>
</tbody>
------------------------------------------------------------------------------------
Fourth Workbook name will Uttar Pradesh.xls
Code | Name | Designation | State |
2001 | Ramesh | A.S.S | Uttar Pradeh |
2002 | Mander | A.S.M | Uttar Pradeh |
2009 | Rane | A.S.O | Uttar Pradeh |
2013 | Ruchika | A.S.O | Uttar Pradeh |
<tbody>
</tbody>
Thanks & Regards
Avinash Kumar Singh