In Excel, can you make a check box to select an item and make the cost of that item appear in a different cell and then only have the checked items display when finished?

karaflanagan
karaflanagan used Ask the Experts™
on
In Excel, can you make a check box to select an item and make the cost of that item appear in a different cell and then only have the checked items display when finished?

I have a spreadsheet that has items to choose from.  When the select a certain one, i want the cost of that item to appead in the column to the right, L so that I can subtotal it at the bottom.  Then I want only the checked items to appear so it can be printed on one page.  

shelves.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
JPIT Director

Commented:
I believe what you want is possible however when I look at your file wouldn't a quantity be more useful than a checkbox? Is it not possible that a person would purchase more than one or two of an item? I can help you with this once I receive your input.

Author

Commented:
Yes that would work.
JPIT Director

Commented:
leaving for the day I will have your solution to you tomorrow morning.
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Author

Commented:
Great Thank you!
IT Director
Commented:
Here is the finished file. Unzip then change the file extension from .txt to .xlsm. All you should have to do is fill in the qty's and then click any of the Create Receipt buttons I made. If you do a print preview when it is done you will see jut the receipt. I recommend making this your template and each time you use it do a save as if you want to maintain a copy of the file for the customer or job. If it asks about enabling macros make sure you do that.
shelves.zip

Author

Commented:
When I save with a file extension of .xlsm, it gives me errors when I try to open the document.  What am I doing incorrectly?  I unzip the .txt file, choose File, Save As, and change the file extension to .xlsm and save it in the desired location.  When I then open that document it brings up:
Excel found unreadable content in 'shelves.xlsm'.  Do you want to recover the contents of this workbook?  
I click on yes and it brings up:
Excel cannot open the file 'shelves.xlsm' because the file format or file extension is not valid.  Verify that the file has not been corrupted and taht the file extension matches the format of the file.
Is there a way around this?
JPIT Director

Commented:
If  you can see the file extension .txt just click on the file and press F2 to rename the file and change the extension. If you can not see the file extension let me know.

Author

Commented:
That way worked.  Can you explain what you did to the file?
JPIT Director

Commented:
When the file is open if you press Alt & F11 it will open the visula basic editor and you should see the code and my comments in green. If you have questions I can try to explain.

Author

Commented:
Will we have to change teh security level each time on a 2003 system?  
Can I add something before I accept this?  I will email you the final what I wanted it to look like...

I just wanted it to look like the attached file t cant get a macro to work in 03 without lowering the macr security---  but yours works great if i can make it look like mine...
shelves.xlsx
JPIT Director

Commented:
Here is the file in excel 97-2003 format, if you do not want to enable macros each time you will need to go to tools - Macro - Security and change the setting to low which is not recommended due to malicious code that could be run.
shelves.xls

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial