Hello everyone, I want to make a product configurator, where products have standard equipment and options and each option has a price. Based on the chosen options, it should give me the total cost. I would like to make this with drop/down lists. Instead of writing a long post, I have attached a picture. I would greatly appreciate if anyone can tell me how I can do this on Excel. Thanks Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar Topics
I run a small business. I want to start keeping track of inventory using a barcode system. I know Excel 'ok', but I don't know programming.' I'd like to be able to do something very simple (for now)... For example...if I had PRODUCT / CODE / INV VALUE A - CODE A - 5 B - CODE B - 11 C - CODE C - 14 I would want to be able to click a button (or scan a code for) : ADD +1 or REMOVE -1 ...then scan the barcode on the product (A) and have it add or remove one, respectively. So, if the row for A is: A - CODE A - 5 I choose 'ADD' (with a button or scan code), then scan the barcode, and the spreadsheet automatically finds the code in the sheet, and changes the corresponding inventory value: A - CODE A - 6 Does that make sense? How might I go about doing that?
Hi All, I am trying to make excel automatically add a leading zero to values which are 5 digits long; i.e. number input is 15185, then excel automatically changes it to 015185. If I put a Customer Number Format of 0##### it works, however, a user could put any length of number into these cells, and if the number is less than 5 digits I don't want a leading zero. Is there any way of writing a small macro to sort this out. The numbers would be input into range B16:223. Many thanks, Andy
Hi everyone....this is my first post here ....and not my last I believe! My question I believe is easily solvable for you cracks of excel. I have a worksheet with a list of rows (item#, date, price, etc). In the last column of this list I can put an x for some of the items. On another worksheet or sheet, I need to autoamtically have a list of the items in the first list above, that have an X in the last columns. I created an example on a worksheet attached just for you to understand. I apreciate all the help I can get. Thank you so much. RG Hello, As the title goes this is as simple as it gets. The macro worked good when I was using excel 2003 but now that I have 2007 everything works for except the resizing (Picture.Width & Picture. Height). Code: I have tried to record some macros while I am resizing the pictures but to no avail the macros are blank. Please help Thanks!
Sorry for the question. Normally I find answers to my excel questions by going through the help tab or by searching on Google. However, I don't even know what question to ask on this one!?! Basically I have created a spreadsheet with several columns, but I have one column that lists the shirt size (YS, YM, YL, AS, AM, AL, XL, 2X, 3X) of each person. Is there a formula that I can create that will tabulate the number of sizes (i.e. AS=2, AM=7, etc.)? In previous years I made a column for each size, and simply placed a '1' in the correct column, and had excel just add the 1's from each column. However, that takes more time and space. I was hoping to streamline it this time around. Thanks for taking the time to read this post. Any help would be appreciated! Thanks, doug Imagine a whole box of lengths of aluminium sections for making windows. To make those windows I need to cut these lengths into smaller sizes. I need to do this economically. How can I use Excel to help me make this a reality. Firstly you would take a big size out of it and then another size out of the offcut piece. And then another size out of the offcut left over. I need to know how many full stock lengths (6500) long it will take to cut all the pieces listed above. Is it possible? You need to take into account the quantity of each size and fit it all in together for the most optimal outcome. See attached example of possible layout. Is there an Excel guru that can help with this - its related to 'drop down menus' I have 2 colombs of data. AT the bottom of the first, I have created a drop down menu using the 'data validation' feature in excel. At the bottom of the second colomb, I have used an 'IF' function that returns a result, which depends on what value is chosen from the drop down menu in colomb 1 The problem I have is that I want the TRUE result from the IF function to be another drop down menu, being the data in colomb 2. How do you write an IF function where the TRUE result is a drop down menu?? I tried to create a drop down menu of colomb2 elsewhere in the spread sheet, and used that cells location as the TRUE value, but this didn't work either... ANy suggestions?? I am trying to do a very simple copy and paste of a simple formula in Excel 2007 and nothing seems to be working. Excel will not let me copy and paste a formula and will only paste the value into to workbook. For instance, if I make a very simple spreadsheet such as: A1 type in 10, A2 type in =A1 (calculated A2 to be 10) B1 type in 5 And then click the copy on B1, and then click paste special on cell B2, the only options it gives me are text and unicode text and so no matter how I paste, cell b2 will always be populated with a value of 5. I cannot imagine a simpler copy and paste and no matter what I do I can't make this work. All cells are formatted as general. It seems that all copy and pasting of formulas in my excel has been disabled. If I open any spreadsheet on my computer, I can't copy and paste formulas, but do the exact same thing on the exact same spreadsheet on any other computer and it works no problem. Any help? Hello - I am using Excel 2007. In prior versions of excel, when copying data, if I wanted to copy visible cells only, I would select 'Go To, Special, Visible Cells Only' and then copy a range a cells. The default was always set to copy everything (including hidden cells), unless I specifically selected copy visible cells only. In 2007, the default is somehow set to always copy only visible cells. Sometimes, I want to be able to copy all cells including those hidden but cannot seem to figure out how to swith this default option. I looked under Excel Options and did not see an option there. I don't want to have to unhide and rehide everything each time i copy. I know i could do the hiding and unhiding via VBA but would prefer not to have to. Thanks for your suggestions.
I am setting up a PivotTable and only want to show the actual raw data values in the PivotTable field and NOT any sum, count, average, max, min, etc etc. How can I do this? I only seem to have the options for sums, counts, etc. There are no options for just presenting the data. So for example, rather than a PivotTable that results in counts of 1, 1, 1 in each cell, I want it to show Compay1, Company2, Company3, etc.
Hello, I want to protect a cell that I have a drop down list in, but I still want the drop down list to work. When I try to protect it, the user is not able to use the drop down list to select other items. I didn't see an option on the protect sheet area. Thanks for any help. Nick Hi there, I have a spreadsheet with some cells setup with a drop-down list containing Y, N or N/A This is being used on a TabletPC but if I make a mistake or need to change back to a blank field I have to invoke the soft keyboard, activate the cell and hit backspace then close the soft keyboard - quite a long-winded procedure just to change an incorrect choice! What I would like to do is add a blank to the list so if I have to revert back to a blank I can just use the stylus to choose a blank from the chooser list. How do I add the option of inputting a blank from the Data Validation List bearing in mind I am using the Data Validation Source box for entering my choices directly and not specifying a range of cells? I have tried adding ' and even a space to no avail. Although not a betting man I would wager there is a simple 'fix' for this but things are only simple if you know how in the first instance! ;^) -- Thanks & regards, -pp-
How do I get the colors to change automatically when I use a drop down list. Per say here is what I am trying to do If a certain 'word' is used from the drop down list I want the background of that cell to change its color to 'green.' And if later I change the 'word' to another from the drop down list, it will change it's color to a specified color. The drop down list that I use was created from cells that have the colors already in the 'word', but I do not know how to make the list show the colors so it puts the word & color automatically in the drop down list to the cell with the drop down (if that makes any sense). If there is a way, please spell it out simple enough for me to understand, as I don't know fully the capabilities of formulas or vba. I want to make a searchable drop down menu. In other words if I click on it and press 'D' I want to see the instances that begins with a D. How do I do this?
Hi I'm not sure how to do this, but I want the Total (column D) to be the sum of the Unit Price (column C) times the Quantity (column A). Is there a formula you can apply to a column or do I have to do it in individaul cells?
I have looked over the forums for information on how to do this, and can not find anything. I have used conditional formatting to identify duplicates in my spreadsheet. I have a unique user ID, which combines the first and last name fields into one. However, in 10,000 there are a number of John Smiths, Joe Adams, etc. With smaller lists, we search manually, and then add a 1, 2, 3, etc to each duplicate to create a unique value for the User ID. My question is: Is there a way to check for duplicates, and then automatically add numbers to the duplicate values to make them unique? If so, how can this be done? So that you will have this: JohnSmith JohnSmith2 JohnSmith3 JaneDoe JaneDoe2 JohnAdams JohnAdams2 JohnAdams3 JohnAdams4 I think I have done a good job in illustrating what I would like to be able to do, but if there is still something that is unclear, I will post whatever clarification is needed. Thank you in advance for your help!!
Very new in this board. If I post this question in the wrong forum please bear with me. There is about 20 staffs in our department and I have made a spreadsheet with 12 tabs for each month of the year Jan-Dec. If each staff have 15 days annual leave each year and how can I make a formular that can automatically calculate the balance of annual leave and entered in the tabs of the following months. For example if staff A used 5 days in Jan how can the balance of 10days be entered in the tabs from Feb-Dec. If he use another 5 days in July the remain balance of 5 days be automatically entered in the tab from Aug to Dec. Likewise if staff A took 2 days sick leave in Jan, and 2 days in Mar how can this sick days be automatically sum up in the months after. I am doing this manually at the moment and it is very time consuming and also very easy to make mistake. Thanks and sorry for this long questions
Hello, My Cell C3 is a numeric value.....I have set conditional formatting to make the text red and bold when the number is equal or less than 10,000 is there a way I can make cell E3 display a message when the C3 condition is true?? or if not a message is there a way to make a message box pop up when my C3 condition of less then or equal to 10,000 is true? how would I do something like this?
I have an image or picture within a worksheet. I want to be able to reference it from a cell so that depending on a validation list a different picture is shown. Is this possible in Microsoft Exec 2000
Is it possible to assign values to names in a list, so that when you validate it as a drop-down list, you can select a name from the drop-down and it's corresponding value will be added to separate cell? Basically, I have survey questions which have five possible responses: Excellent - Very Good - Good - Fair - Poor. We want to assign a value to each, 5 for Excellent, 4 for Very Good and so on, so that when a response is selected from a drop-down, it's value appears in a separate cell (so that we can calculate a total and average score from the selections). Thanks B
I use a excel file through the course of the day and need to insert the current date in one column and the current time in the next column. I want to be able to just highlight the selected range of cells I need to insert into and hit a macro button and have the date and time inserted into just the cells I have highlighted. I'm not sure how to make this work with just the cells I've highlighted. Any help any one can give me would be greatly appreciated. Thanks! Mike I have the strangest problem... somehow, right clicking a cell doesn't bring up a menu anymore. It happens only when I'm in Excel only... it still works even if I bring up macro editor within Excel... it only doesn't work when I'm in Excel. I've tried Options and Customize... nothing there seems to work... HELP!!!
A previous poster explained what I also need; there were no responses, so I thought I would try again. Does anyone know of an Excel template--or a small stand-alone program--that will calculate the interest/principal breakdown when payments are varied in amount and frequency? Free or low-cost, please. I need one that will work on my Mac/Office 2004. I will need to print out periodic reports. Here is the way the previous poster described it: 'Excel template: Loan Amortization for random/irregular payments, figures days between payment dates. I have a loan with a variable beginning balance and irregular payments with annual large payment. (based on collections) Would like to enter payment and date. then Excel would figure days since last payment, interest amount, principal amount, Ending Principal balance. And total interest paid, total pricipal paid If I change the starting principal, excel would recalculate all entries.' Thanks very much. I am trying to calculate time based off a non-conventional quarter hour time system example; 8:00 to 8:07 = 8.0 hrs 8:08 to 8:23 = 8.25 hrs 8:24 to 8:38 = 8.5 hrs 8:39 to 8:53 = 8.75 hrs 8:53 to 8:59 = 9.0 hrs I am having trouble writing an equation that would sum the clock-in and clock-out times (2 per day) and display the total time in these quarter hours and adding an additional hour if it is >= to *:53. Any help would be great. I have a list of 5 buildings each with different unit counts, and an average price sold for each building. How can I get the average price of all units sold? A B 312 $1000 54 $1010 35 $1835 32 $1028 53 $1937 |