Closed Thread
Results 1 to 4 of 4

Please help, i am completely lost

  1. #1
    Registered User
    Join Date
    07-02-2011
    Location
    New zealand
    MS-Off Ver
    Open office excel
    Posts
    7

    Post Please help, i am completely lost

    Hi, I am in need of someone who can lend a hand with this form i am trying to create. What i am trying to accomplish is a excel form of list of games to email to my customers that have purchased a portable Hard drive.

    Customers can select the games they like by using a checkbox to select game on each line, when they are select each game, the spreadsheet will automatically calculate the 3 memory categories

    Eg: the first line is a game that is 4.59GB, so when a customer uses the checkbox to select that game, the Memory used will become 4.59GB, the Memory Free would be 495.41GB and the used would be 4.59.

    Each game that was select would add and minis of these 3 totals when each game is selected or deselected

    The aim is if a customer buys a 500GB portable hard drive then they can see for them selves how many games they can put on the Hard drive. I would also like to know if it is possible to set a limit so if they go over 500GB then a warning message will appear.

    Last but not least, once i have all 500+ games in spreadsheet all calculating accordingly, would it be possible to convert it to PDF or will this idea never work as PDF as a flat document and selection and formulars will not work?.

    anyway, sorry i have a good idea of excel but when it come to in-depth stuff like this, it make me want to bang my head against a brick wall lol


    Many thanks
    Cozzienz

    Memory FREE: 0.00GB
    Memory USED: 0.00GB
    MAX CAPACITY: 500GB


    ColumnA
    Checkbox thumbnail 2011 FPS Duke Nukem Forever BLES01147 4.59GB

    Checkbox thumbnail 2011 ACT Infamous 2 BCUS98125 14.2GB

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Please help, i am completely lost

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    07-02-2011
    Location
    New zealand
    MS-Off Ver
    Open office excel
    Posts
    7

    Re: Please help, i am completely lost

    Sorry, have created new post so you can remove this one

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Please help, i am completely lost

    You were asked to edit the title of this one, not clutter the forum with unnecessary posts & make work for me tidying up!!!!

Closed 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