PLEASE HELP ignorant student! - Page 2
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: PLEASE HELP ignorant student!

  1. #11
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Cool! But how do I get the data that I have entered on the beautiful form I have created, across into a table on the next sheet so that I can 'collect' all my entries and do calculations on it...?!!

  2. #12
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sorry Jeanie, but without even a little snippet of VBA i'm not sure that would be possible.

    Formula alone cannot write to other cells. The only other perceivable way of doing it is to have formula in sheet 2 to pick up the values from your "worksheet-form", but there would be no way for the formula to remember old values that were previously in the form.

    But if you can get away with just a little VBA then you can easily wire up your form to your data sheet. Otherwise, use access (as you say) or use the built in data form.

    Why can't you use VBA - thats screwy.

    <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;"> DALEY :P </td></table>

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just to get you started, from the mentioned Forms toolbar, place an option button on the worksheet. Now right click on the button and goto |Format Control. Hit the control tab on the now opened dialogue box, click in Linked Cell. now click on the cell you'd like to put the value from your option button, this can be on any sheet.

    Also, you could look at the buttons on the |Control Toolbox. to link cells from these type of controls, again Right-Click on the control you have and select |Properties|Linked Cell, you'll have to type the link in.

    I don't know if your thinking of trying to fill in the form on 1 sheet and have a list on the other, i.e. from many times of filling in the form, sort one under the other. Unfortunatly youe NEED to use code for this.
    BUT! if you want to create a form the does calculations from various inputs then your on to a winner.

    Any of this any help?? if you need more just ask.
    "Have a good time......all the time"
    Ian Mac

  4. #14
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    And Again!
    "Have a good time......all the time"
    Ian Mac

  5. #15
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks guys for all your help, at least the experts have now told me that I can't do it otherwise I would have carried on and eventually gone insane! I will have to try it without code - my tutor would notice despite the temptation!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com