1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

3 variables

Discussion in 'Business Applications' started by AMorrison0903, Apr 17, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. AMorrison0903

    AMorrison0903 Thread Starter

    Joined:
    Apr 11, 2008
    Messages:
    79
    hello guys...

    I have 3 user inputed variables. I will name as "Start"... "Increment"... "X".

    Start will be the starting weight... 1 pound, 2 pounds, 10 pounds, whatever you wish...

    X is the percent value

    and Increment and how often the X value increases...

    for example... i want to start at 10 lbs, my Starting percent value is 1% and my increment is 2...

    I need to fill a column, 1-40 cells of a single column, i need the first cell in column A to be the starting weight and go in consecutive numbers down through the 40th cell.
    and then in the column next to it i need to fill in the corresponding cell with the percent value necessary as declared by the increment and x value.

    as in my example...

    Column A Column B

    10 X
    11 X
    12 X + X
    13 X + X
    14 X + X + X
    15 X + X + X
    16 X + X + X + X
    etc...

    does this make sense?

    Also, the user inputs will be on sheet one, the results on page two.

    thanks guys!
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Hi Amorrison,
    Do you have a sheet shwoing what you expect to see? I think I get the idea but seeing helps.
     
  3. AMorrison0903

    AMorrison0903 Thread Starter

    Joined:
    Apr 11, 2008
    Messages:
    79
    hey, no i dont have a sheet drawn up, what i showed in the original post towards the bottom is what it should look like...

    apparently my formatting didnt stick...

    Column A has the Numbers

    Column B contains the X's...

    does that help any?

    i can draw one up real quick if that would help...

    thank you!!
     
  4. AMorrison0903

    AMorrison0903 Thread Starter

    Joined:
    Apr 11, 2008
    Messages:
    79
    here we go... i attached a file... let me know if this helps...

    Andrew
     

    Attached Files:

  5. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Thanks, If I have questions I'll get back to you.
    It's midnight here (the Netherlands) so I'm off to bed.
    Get back to you tomorrow
     
  6. AMorrison0903

    AMorrison0903 Thread Starter

    Joined:
    Apr 11, 2008
    Messages:
    79
    awesome, thank you sir, i appreciate it!
     
  7. AMorrison0903

    AMorrison0903 Thread Starter

    Joined:
    Apr 11, 2008
    Messages:
    79
    any ideas to this?

    thanks!
     
  8. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Hi ther,
    I have attached a zip file containing an Excel sheet with some buttons.
    Also I have attached the VBA code which is already in the sheet.
    I didn't document what I dit but I think you could work it out.

    You use the button to input, it will ask for one value at a time and if accepted it will be added to the result sheet, if the wweight is not found an new row is addes and the first column is filled, if the weight is already present a new coilumn is added with the increment value and the results list is again sorted on the weight column.
    Have look and let me know if you need some explaining about the code.
     

    Attached Files:

  9. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    And here is the last version including the vba code as separate file

    Good luck, have fun and let me know if there is anything.

    I did not really document anything but with a little common sense ... it will make sense.

    (y)(y)(y):):D
     

    Attached Files:

  10. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/704699

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice