Hello, I am attempting to create a product configurator for systems my company sells. The configurator consists of about 5 computer systems, and contains about 10 different configuration options. It also displays pricing and creates a part number for the configuration. I have this half done; I am able to select systems, select configuration options that create a part number for each component, add up the price in a column, and then concatenate the individual part numbers into a long product configuration string.
I have 2 worksheets; an interface pane containing the configurator for our sales personnel to use, and a data worksheet containing 3 columns for: Items, Config Numbers, and Prices. I am selecting the data and using data validation to pull into drop-down lists, and VLOOKUP to create the configuration number and pull the pricing. This all works very well. Now my problem: Some of the computer systems are not compatible with certain components, or only allow one or two components from several configuration drop-downs. My problem lies in defining which items are displayed in subsequent lists when selecting from first ones. I have figured out how to do this on one level (by using =INDIRECT(XXX) in my Data Verification list source field) but it gets tricky when selecting one option affects the results that are shown on multiple configuration lists. Does anyone have a suggestion on a better way to do this, which will allow for greater complexity and configurability?
I can provide more details about what I have done if needed. Thanks for your help! I have never really used VBA and so am completely stuck at this problem. I need to create a macro which auto-populates a master worksheet from the individual user sheets in a shared workbook. Sheet 1 is the master sheet 'Team Stats'. There will be an undetermined number of individual worksheets to accomodate new staff. Each worksheet will be identical, using columns A-I with row 1 having the headings: Date, Name, Reference, Value, Price, Age, Purchased?, Destination, Add.
Products (the last 3 columns will have a drop-down list which will be used to enter data into the cell). There will be a varying number of rows in each of the individual sheets. If possible I would like the macro to run every time data is entered into one of the individual worksheets. If this is not then it would be fien to update every time the workbook is opened. If anyone can help it would really cut down the time I spend collating these stats every day! 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. I found this solution for 'drop down list with hyperlink' but it did not work. Perhaps a better solution is to use a workaround that relies on the HYPERLINK function to refer to whatever is selected in the drop-down list. For instance, if you have your data validation drop-down list in cell A1, then you might put the following formula in cell B1: =HYPERLINK(A1, 'Goto Link') The solution directly above provides exactly what I am looking for in the field where I write the formula, but it fails to hyperlink.
I have created a drop down list and linked each one of them to a specific worksheet. When I select them individually they link to appropriate worksheet. But when I select them in the drop down list I receive the following error when I select the Hyperlink in cell B1 as directed above. 'Cannot open the specified file' Any thoughts?
I am looking for the code to select the visible data after applying a data filter. Actually I know how to select the data after applying the data filter but the issue is I am not able to exclude the header row and give the target range as used (non-blank) rows only!! I am using below code to Select the Visible rows in the target range: Code: Range('A:p').SpecialCells(xlCellTypeVisible).Select Problems in this code a 1) after applying the filter, while selecting the data it is selecting all the rows in given range till last row on the workbook. I need this to select the the data only till the last used row in the given range.
2) It is not possible to provide the address of the first row after we apply the filter since the first row address may change depending on the values in the table. 1st time when I am running the macro the first row in the visible filtered data is starting at Cell address A4 and next time when I will run the macro it may be A6 3) The Code is also selecting the 1st row which is a header row. How can we exclude it from selection. Some one please revert with the solution. Thanks in advance. I have AplphaNumeric part numbers that sometimes contain hyphens or decimals. In order to make them more searchable (since people don't always use the hyphens or decimals properly when they search) I would like to create all the possible variants of the part number, but with one formula.
So AHW18.787 becomes AHW18 787 and AHW18787 with =SUBSTITUTE(A1,'.' ,' ') and =SUBSTITUTE(A1,'.' ,') respectively, and AHRTW-A18-7007 becomes AHRTW A18 7007 and AHRTWA187007 with =SUBSTITUTE(A1,'-',' ') and =SUBSTITUTE(A1,'-','). What I need to be able to do is merge these formulas into one, so that no matter what format the part number is in A1, I get a version of it with spaces in B1, and a version of it with no spaces in C1.
I just have not been able to nest it all together - is it even possible with this command? 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!!
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?? 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. Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet.
According to the official boilerplate, Tony Stark (Downey) this time has his back against the wall on a quest to find his enemy. “Stark also discovers the answer to the question that has secretly haunted him: does the man make the suit or does the suit make the man?” Marvel’s iconic superhero first appeared on the pages of “Tales of Suspense” (#39) in 1963 and had his solo comic book debut with “The Invincible Iron Man” (#1) in 1968. Download video iron man. Is presented by in association with Paramount Pictures and DMG Entertainment. 2ND UPDATE: just debuted its first full trailer for which will be in theaters in Digital 3D and RealD on May 3, 2013. Once again starring, Gwyneth Paltrow, and Don Cheadle, this threequel is directed by Shane Black who also wrote the screenplay with Drew Pearce.
I am running Excel 2011 for Mac. I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data. I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it. Appreciate any help, let me know if you have any further questions. I would like to copy a small table from Word into one cell in an Excel worksheet.
The first column of the table is a list of numbers. I tried converting the table into text with manual line breaks and tab stops to divide columns and rows, but that didn't solve my problem. Excel pastes the data into several rows. When I try to merge them, I get a warning that the selection contains multiple data values, and merging into one cell keeps the upper-left most data only.
What I tried that didn't work:. Formatting the Excel cells as text before pasting the data.
The various options for 'Paste Special.' The closest I got was inserting the table as a Document Object, which could be a workaround, I guess. What I am saving for when all else fails:.
The obvious solution of copying row by row into one Excel cell. The data in the table is information about my dad's medications.
I would like to have reference charts of how to identify the strength of each tablet by its color and markings. I got the info from the manufacturers' websites and entered it into tables in Word, which I would like to copy into a more comprehensive file I am creating in Excel. The first column of each table is the strength of the tablet, entered as 1 mg., 2 mg., etc. The subsequent columns describe the shape, color, and markings. There are 3 tables, each with about 4-5 rows. Is there a way to copy each one - whether as a table or as text - into a single Excel cell without losing data?
I know this question has been asked a bajillion times, so I apologize for the redundancy. I am working with an Excel spreadsheet and saving it as a.csv file in order to upload to an application that parses out the.csv data as transactions. The system requires.csv files, so this is how I need to save my doc (with this extension). I have been successful at preventing Excel from coverting that long number into scientific format. I have saved as a TXT file, pasted the longer number and it displays correctly. That is all good. But I have to save as a.csv.
So if I do that, close the Excel window, and then open again (as the.csv file), the numbers are back to being displayed in scientific format. I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file. But again, the second I save as.csv, close the window and then open that file up again, that dang scientific format is back. Does anyone have any idea of how to work around this?
Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to 'stick' so that they don't revert back to scientific format when I reopen the file? Thanks so much for your help! Hi all, I've had a long search through your pages to see if this question has been answered before but having browsed through about 50 pages worth of threads I couldn't see anything, but if I am repeating prior information I do apologise. I've written a macro that is relatively simple. It just takes some information in one format, rearranges it, adds some formatting and performs some calculations. Nothing incredibly fancy but it works fine on my computer.
Now, I need to share this macro with some other people, so basically I've just sent that excel file on to the people that need to use it. Should be fine and in most cases it is, however there is one user who although they can open the file, can't seem to get the macro to run properly. It seems to get a small way through the macro but then stop with no error messages or any sign that it hasn't completed properly. I have checked Macro Security level and that is the same as mine, Tools - Add-Ins is the same, In Visual Basic, Tools - References is the same as mine. It is the same Operating system and the same version of Excel. I have even signed into this person's computer as myself (it's a big company network thing) and tried to run the macro and it works fine, so there is nothing wrong with the hardware. I've googled and searched and tried everything I can think of but I'm no closer to solving this problem, so if anyone has read through this wall of text and can come up with a possible solution, that would be greatly appreciated to save me from tearing ALL my hair out!
Thanks very much for your time. Okay, so I tried (for hours) to find a solution to this and have finally gotten frustrated to the point where i think asking here will be my best bet. Basically I want to export data from excel worksheets to various places on a word document I had. I have created a word template as well as bookmarks for that template, as that seems to be the recommendation for performing such a task with excel.
My problem is. I basically have 1 constant worksheet that contains all my affiliates info (Name, Address etc), which i'd like to use to populate some bookmarks in my word template, and then i have another worksheet for the previous month, indicating sales etc for that affiliate. I intend on adding a new worksheet every month that i would use to create new invoices. Furthermore, i'd really like to be able to update a new file (or perhaps a new page on the same file) for each company with the use of a button, similar to the one's you'd see in an access form. Can anyone help? Let me know if you need me to clarify.
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.
. PLEASE FULLY READ THE SIDE-BAR BEFORE SUBMITTING A POST!
SUBMISSION GUIDELINES FAQ PROBLEM SOLVED? OPs can reply to any solutions with: This will award the user a and change the flair to SOLVED. TO APPLY CODE FORMATTING Use 4 spaces to start each line You can select code in your VBA window, press Tab, then copy and paste into your thread or comment. PROVIDE YOUR DATA!
Include a or use the website to generate the reddit table markup from your spreadsheet. Recent ClippyPoint Milestones!
Sql injection tool get cc cvv itunes. Congratulations and thank you to these contributors Date User CP 1500 50 10 400 50 10 25 50 25 10 10 10 A community since March 11, 2009 Download the official to convert Excel cells into a reddit table.