Please help, i am completely lost

**cozzienz** · 07-02-2011, 01:24 AM

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

**royUK** · 07-02-2011, 02:31 AM

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