Become a Certified GST Practitioner with CA Arun Chhajer. Register Now!

How to create database in excel

(Guest)

i want to create the clients database using excel.

in this i want fields - Name, address, contact, pan, tin, tan,....................................,etc

In sheet 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.

so please guide me in this.

Reply
Follow
Share

9 Replies

(Guest)

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.

Upgrade to CAclubindia Pro. Subscribe Now!

mehul (ca final student) (83 Points)
Replied 20 June 2012

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

khushal (ACA; CS Professional Gr. II & IV Cleared; Pursuing ACCA UK & Bcom Graduate) (63 Points)
Replied 20 June 2012

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

(Guest)

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

gourav (accountant) (25 Points)
Replied 20 June 2012

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.

Upgrade to CAclubindia Pro. Subscribe Now!

(Guest)

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

Pulkit Sharma (CA Practice) (458 Points)
Replied 22 June 2012

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 :)

(Guest)

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 :)