How to create database in excel

Simple, prepare database in three sheets, one for data entry, second uneditable and third editable and data filter or search can be made like such type.

YOU JUST USE PIVOT TABLE FOR BETTER DATA BASE MANAGEMENT AND REPORTING

Well You can make use of Vlookup, PIVOT for better Database Mgmt & reporting.

Yes you can use pivot table for database management.Its the best option.It is  a part of syllabus of andhra pradesh board syllabus.

please give me a example create database in excelsheet 1 - i want to make data entry. and want that data to go automatically in sheet 2.that sheet 2 should be uneditable but it should allow me to create the necessary reports.

i am still not getting the same. please tell me in detail.

download excel accounting file from www.sataxsolutions.com/projects.html.

In that file you can check NEW ACCOUNT BUTTON, i think you need something like that.

If you need database like that than, i can make it for you but it would be chargeable :)

Originally posted by : Pulkit Sharma
	download excel accounting file from www.sataxsolutions.com/projects.html. In that file you can check NEW ACCOUNT BUTTON, i think you need something like that.   If you need database like that than, i can make it for you but it would be chargeable :)

Perfect answer to above query

Very simple. Just create 3 sheet. In first sheet make the field Name, address, contact, pan, tin, tan,....................................,etc

Insecond sheet just write copy formula for copy data from 1st excel sheet.

like sheets("Database").cells(lastrow+1,1).value=userform1.textbox1.text
sheets("Database").cells(lastrow+1,2).value=userform1.textbox2.text
etc

and in your 3rd sheet create for uneditable.

Thnaks

https://dailyonlineproduct.blogspot.com/