Is there a way I can set up the worksheet so that in one cell I can type out for example product codes/numbers and by doing the description for the product will come up in another cell. Rather then copy and pasting very the many different product descriptions?
Is it possible to have a macro run as soon as there is text typed into cell A2? Basically, I have a form that needs to be filled out, but somehow, users forget to put their name in the box. So I don't want any information to be able to be typed in until a name is entered.
when I type a 6 digit date into Excel cells formatted to dd/mm/yyyy very strange dates are being displayed. Tried opening a new book - just the same result. All is ok typing with the / in between but I don't usually have to do that. Regional settings have been checked and formatting etc.
Is it possible to click on a cell and use the cell info as the input data for a search instead of typing data into a cell for a vlookup?
For example, I have a spreadsheet with numbers corresponding to stock codes. Would it be posible to just click on the stock number to return the information on the stock (levels, sizes etc...) instead of typing the stock code in for a vlookup calculation.
I have written code in which cell color changes according to cell value. To change cell value I have used drop down list (Data/Validation/List). Main question/problem is code works well when cell value is changed by typing from keyboard only.
Code doesn't work when cell value is changed using drop down list.
When I type numbers in the cells from D4 to D14, E4 to E14 and so on, the particular cell should turn into "Green". All the the cells will remain "yellow" and blank until numbers are entered based on the daily cleaning of machines. When particular machine no is entered in to a cell cell, that cell should turn green(this shows that "service is done for that machine")
I've built (but not completed) a spreadsheet used to organize multiple Bill of Material lists. This list is a row-by row list of products with information relating to a specific part number including: Mfg, Part#, Qty Used, Cost Ea, Vendor, among many more.
Here's what I'm trying to accomplish first. As this list grows, my intension is the be able to recall a row of data (or control what columns of the row are recalled) from this list and be able to easily add them to the list. I would like to be able to do this by typing in data in one cell in the row (like the Part#), and then have a macro or VB code that will automatically fill in a defined number of columns with the descriptive data like: Mfg, Cost Ea, Vendor, etc.
Currently, the data for the rows (if it already exists) would reside higher up in the list on the same worksheet but could also potentially be on another tab in the workbook.
I am creating a spreadsheet that when I type the product series in cell A1, it will automatically know to enter the corresponding catalog # into cell B1. I will be doing this for hundreds of product series.
If I type AEP into cell A1, the worksheet will automatically enter #123 into cell B1,
If I type DEB into cell A2, the worksheet will automatically enter #458 into cell B2,
and so on...
I understand that I will have to create a master list with what series goes with each catalog #, but I am not to sure where to go from there?
I'm trying to convert various codes from one column of an excel spreadsheet into different codes in another column. I was able to accomplish this with "If" statements, however I'm only able to string together seven of these statements in one command. Is there a better way to add formulas for more than seven conversions? Below is a copy of what I've done so far with the seven converts:
I need help to this : When i type a number to a cell and press enter , i want to check if this number exist in a range of cells (in sheet 2) , and if exists , excel show me a message. Actually i use it for my *** club. Number is the client code. When i writte 50 in a cell , i need from excel to check if this client own me money , and show me some message..
I created a financial forecast model from scratch. The model is self-contained and has no external links.
Before firing a question at you, let me explain briefly how the model works. I have an assumptions tab, several costs tab from various departments that ultimately feed the Results tab (target price on a monthly basis) . Let's assume that my target price is on line 200. To me more specific, for Jan09, the target price is on B200, Feb09 on C200 and so on.
Management will feed the model themselves, given that they are assigned specific areas that they can input their forecast.
Issue or question to you
I would like to track historical changes to the price on line 200 on my target page. That is for every individual change and their impact on price.
To illustrate this let assume the following:
Let say User A made several changes on his forecast, I would like the macro to automatically record the individual change that has been made and the impact it had on the target price on line 200.
Assume that User A made two changes on his forecasting sheet. He increased the cost of supplies by $50,000 (on one cell) and increased the cost of labour by $10,000 (on another cell).
What I would love to have is a macro that would record the changes that User A changed; (i.e. cell, tab, user) after he entered the $50,000 and after he entered the $10,000. This would be recorded on a separate sheet.
Thus, immediately he entered the $50,000 on the cell and press it would record the change and the impact it had on price on the target page. Then when he entered the $10,000, it would do the same.
The format of the "changes sheet" that would contain the changes would look something like this:
USER..Date..Cell changed...Tab..From value..To value. Price Before Price after Impact (Price before less price after)
I am aware that there's a lot of details but if you don't understand the issue, it's very difficult for you to resolve.
I assume that it requires a VBA code of some sort to set this up. Given that I am not familiar (a true dummy) with VBA, I would need like a step by step instruction.
The codes in E column are what is entered in a worksheet range (user cannot see the list). Needed is to show both the two-character code in column E and the text definitions in column F in the dropdown. As data validation now works, users only see the two-character code and are not remembering what the code stands for - they need to see the definition.
Is there a way to show both the two-character code from column E along with the text in column F? When user selects, only the code would be entered in the target cell. (Is data validation the correct technique?)
I have set this problem up in closely located cells to construct the issue. In reality, the validation list is well off-screen from where the user is actually inserting the codes and there are many more codes/definitions.
In 1 cell i need a forumla to give me a starting number and take one away each time a code or codes are dislayed in a cell range. Something like this
A1 = 23 days or any number days i needed
Cell range B1:C52
every time a selected 1 or 2 letter code appears in the cell range i want A1 to subtract 1 day from the starting number, i would need it to subtract half a day if one code appears ie HD, the codes may be P, OT, HD
When I'm doing cells in a column, there are times where I start a word and it tries to complete the word based on what I wrote before. For example, I'll put Base I, Base II, Base III... etc.
How do I get it to add the word base, but then I can continue typing the numeral after it? I do not want to create another column after with the numeral. So as I type B, A, [click certain button and continue typing] II
I'm in need of a macro that takes data from cells in column A and moves them into different cells. Each block of data includes a company name, contact name, address and usually (but not always) phone, fax, email, website, etc. I want to move each set of contact info into a set of cells that begin in column A, starting with company name. refer to the attached spreadsheet
I'm working on an Excel spreadsheet and basicly i'm inserting manually data from a lot of paper forms.
It isn't a dificult thing, but is boring, because I have to do more than 2000 forms per week! I want to accelerate, and how to do that
Problem: "Address"! The Excel page that i'm working has a column to feel with Addresses manually, but I have a table with all correct Address names from the city that I'm working about in other page.
What I would like is when start typing some keyword from the Address cell, it could show me all the choises of input (based on the correct Address Table)
Excel, by default, show, by exact order, all the choises, already typed on the same collumn. I don't want that.
- imagine I have the Table 1 (representing the table with all city adresses) with a collumn called 'Address' with:
A1 - Street ZXY A2 - Avenue QWE A3 - Street QWE A4 - Avenue ZXY
when typing on another Table, if I write something like “QWE” show me the A2 and A3 to choose wich I'm going to feel, and the same to “ZXY”, showing the A1 and A4. Other thing, if I write “QWE street” may show A3 also. Keyword is what i'm talking about
When I type a eMail address, such as: " email@example.com " into any cell and then touch enter, it automatically becomes a hyperlink coloring it blue and underscored. I do not want it to be a hyperlink, for when it is a hyperlink, I have to click on remove hyperlink.
I have been working on a Software Audit list that has been created by someone else. He has created an Application Colum and under that is a drop down box. I want to be able to search by typing in the first letter, i.e. 'S' but currently I just have to scroll down.
Do I need to create and Active X Combo Box to do this or is there another way? Also, is it possible to search on the first two letters, i.e. 'se'?
Is there a way to turn off those annoying error message boxes that pop-up when a line of code is incorrect? I pretty frequently go to another area of code to grab some previous code to copy and paste, and the error message box pops-up, so I have to hit OK to close it. It would be nice if it still highlighted the problem red, but I'd even give that up for those boxes to go away.