+ Reply to Thread
Results 1 to 3 of 3

bigger data hidden in the cell? Is it possible?

  1. #1
    Forum Contributor
    Join Date
    06-28-2009
    Location
    newcastle, uk
    MS-Off Ver
    Excel 2010
    Posts
    187

    bigger data hidden in the cell? Is it possible?

    Hi

    I will try and explain this as best I can. I have complied a database and I was wondering are you able to add a large amount of data into one cell and by clicking on the cell all the data comes up on the screen?

    To be more specific I have a database with horses names and there best number at a certain distance. I get this data from an excel sheet which can sometimes have 20 of the horses distances and numbers, to which i then take the best and add it to the database. Is there are way of adding a tab/box whereas by going to that i can access the whole of the numbers and not just the best number i have?

    Sorry if its confusing to read.

    Any help would be greatly appreciated.

    Gemma

  2. #2
    Forum Contributor
    Join Date
    06-28-2009
    Location
    newcastle, uk
    MS-Off Ver
    Excel 2010
    Posts
    187

    Re: bigger data hidden in the cell? Is it possible?

    Okay i think i am getting somewhere. I have managed to import the necessary data from excel into access and it is on the side of the navigation bar. Am i able to add a kind of hyperlink so that when i go to a certain cell on access it will take me to the sheet i have imported from excel?

    thanks
    Gemma

  3. #3
    Registered User
    Join Date
    08-14-2009
    Location
    Istanbul
    MS-Off Ver
    Excel 2003 and Excel 2007
    Posts
    1

    Re: bigger data hidden in the cell? Is it possible?

    I thing you can do with pivot tables.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1