Posts by Mkalsem

    I really think I will like the way the picture thing is working. I appriciate your help I didn't even know the camera existed. I think this will be very good for me and my data base.


    Thanks so much for the help!
    M Kalsem:lol:

    I have been using that method but can not get a formula that allows me to open to the sheet I want. It acts like it will but it will not!


    :no:


    Do you know the way I would right it? I thought I had it when I got into the note book then was really let down when I could not get the individual pages.

    I am not sure that I even know how to make this message board work. I am new to this so please excuse me if I do a dummy!


    Okay I have a main work book and 3 differend workbooks "under" that one. I want to be able to click in a cell and have that command to mean to take me to a specific page in a different work book. I can get it to go to a different workbook but not specifically the page. I also can get the value of a cell on a page from a different book. I really need to be able to get to the whole page.


    Thanks for any help from anyone. :D

    Well Hi to every one and thanks in advance for the help.


    I am trying to join the information from several work books together while keeping each an individule collection. I have a Main workbook that has many clients names and profiles listed. From that Main I want to be able to click in a cell and have it mean to move to a different workbook (say the medical workbook). I can currently do that however, I would like to go to a specific page in the work book for just that one client. What I currently get is the whole workbook no control over the page.


    This way I could start with a client in the main and go all the way thru seeing all the information for that client or I can start in just the medical file and update each clients care in only that file. It, of course, would then updated from either direction.


    The frustration is caused by not being able to select the individual worksheet to be the result of the jump from the main worksheet cell.


    Thanks MKalsem