Hi I have a work sheet with a lot of data in it relating to time worked each line is a separate day.
In my excel book it states that I can turn this work sheet data in to a database it states that I have to highlight the data + 1 line and then go to the data menu and select "set Database" but there in no item in the data menu with that name! I have tried searching the help files but have not been able to find anything except how to import or link to an external database. And I do not wish to create an external database.
Can any one shed some light on this for me?
Thanks
In my excel book it states that I can turn this work sheet data in to a database it states that I have to highlight the data + 1 line and then go to the data menu and select "set Database" but there in no item in the data menu with that name! I have tried searching the help files but have not been able to find anything except how to import or link to an external database. And I do not wish to create an external database.
Can any one shed some light on this for me?
Thanks
