Using excel as a database
 

I have an excel sheet used for entering data, I am now hoping to expand the
sheet to use as a database so everytime i add a new result i can add it to
my database, I also then want to be able to search the information, Due to
the volume of data being generated it would also be required that more than
one person can use this at the same time even if it means having a seperate
data entry file for each user.

I am not a fan of access so woul much rather keep this in excel, but have no
experiance in writting code at all.

Thanks

Using excel as a database
 

Tushar Mehta (MVP) has a tutorial on using Excel as a database, he

http://www.tushar-mehta.com/excel/ne...cel/index.html

Hope this helps.

Pete

On Aug 29, 11:11*am, Miree wrote:
I have an excel sheet used for entering data, I am now hoping to expand the
sheet *to use as a database so everytime i add a new result i can add it to
my database, I also then want to be able to search the information, Due to
the volume of data being generated it would also be required that more than
one person can use this at the same time even if it means having a seperate
data entry file for each user.

I am not a fan of access so woul much rather keep this in excel, but have no
experiance in writting code at all.

Thanks

Using excel as a database
 

This looks like it will be very helpful, unfortunately I do not know how to
do the tables part because the headings are all in one column.

"Pete_UK" wrote:

Tushar Mehta (MVP) has a tutorial on using Excel as a database, he

http://www.tushar-mehta.com/excel/ne...cel/index.html

Hope this helps.

Pete

On Aug 29, 11:11 am, Miree wrote:
I have an excel sheet used for entering data, I am now hoping to expand the
sheet to use as a database so everytime i add a new result i can add it to
my database, I also then want to be able to search the information, Due to
the volume of data being generated it would also be required that more than
one person can use this at the same time even if it means having a seperate
data entry file for each user.

I am not a fan of access so woul much rather keep this in excel, but have no
experiance in writting code at all.

Thanks