I am trying to set a check register example and want to prevent the user from
entering the same check number twice. Is this possible in Excel?
Hello,
First and foremost, I am on Windows XP and using Excel 2003. I have some moderate level of understanding of basic Excel functions and formulae, but zero experience with VBA and macros.
All right, now that that's out of the way, let me start off by stating what I am trying to accomplish: I have a workbook with several sheets. Various users other than myself will be filling out drop-boxes that I have created on the sheets of the workbook. Based on the results of these users' input, I want to generate a list that pulls some data from the tables on the sheets these folks are working with and consolidate it on a separate sheet. I will not know how many rows will be needed, as this will change as the drop-boxes are altered. I also need this consolidated list to update while the other users are still working on their parts of the document.
Let's try to illustrate with an example:
-Sheet 1, 2 and 3 have the following (or similar) information:
|---------|-Front-|-Side-|-Rear-|
|-Aston-M-|-Pass--|-Pass-|-Fail-|
|-Lotus---|-Fail--|-Pass-|-Pass-|
|-Tesla---|-Pass--|-Pass-|-Pass-|
|-Ferrari-|-Pass--|-Fail-|-Fail-|
Each of the Pass/Fail fields is a drop-down list that I have defined, but the actual results will be reported by other users.
On Sheet 4, I would like to generate a list that looks through Sheets 1, 2 and 3, finds all of the "Fail" results and then creates a list on Sheet 4 that lists the contents of Column A (the name of the car), then the title of the column in which the "Fail" was reported so that they can put any notes related to the failure on Sheet 4. Here's an example of what I'd like to see *magically* appear on Sheet 4 based on the results from the example above, where column A and B are created automatically and the user can then fill out column C:
|- Aston-M -|- Rear- -|- Note: Test Dummy fatality on initial rear impact -|
|- Lotus-- -|- Front -|- Note: Test Dummy ejected from vehicle -|
|- Ferrari -|- Side- -|- Note: Test Dummy decapitation -|
|- Ferrari -|- Rear- -|- Note: Test Dummy spontaneous combustion upon impact -|
My hope is that this could create one consist list of all of the "Fail" conditions and allow room for additional notes to be taken.
I have been scouring Google looking for some guidance, but have yet to find any. I know that I could use VLOOKUP and HLOOKUP to grab the values that I'm looking for, but I believe with this approach, I would likely end up with a ton of blank cells or gaps in the list. I'm sure there has to be a better solution out there.
Any help would be greatly appreciated, and thanks in advance!
I am looking for a way to auto-update a cell when another value is entered.
When an order is entered, this value must be subtracted from the current stock.
Example:
(sheet1)
Artice nr: 29008
Ammount: 25
(Sheet2)
Current stock:
Artice nr: 29008
Instock: 60
Left: 35
To order: 25
--------------------------------------------------------------------------
But a few things;
I have got 1070 different article numbers.
The form with article number and ammount needs to be printed and ereased after by pressing a butting checkout (which would be the easier part of the whole issue)
--------------------------------------------------------------------------
Best regards,
Erik
Erikdekamps@hotmail.com
how do i get excel to tell me i have entered a duplicate number in a specific
column
Hi everybody!!
How can I sum the values as they are entered in the same cell. This is, if I have 2 in A1 and then I type 2 in A1 then I should get 4 in A1 and then If I type 2 again I should get 6, all in A1.
I hope this is not to confusing.
Thanks for any help.
Basically what I am trying to do is have a Userform pop up allow them to enter in some numbers and then hold those numbers and use them in the rest of the macro. I just cant seem to figure out to refer to the values enter in the macro.
Any help would be awesome.
Thanks
This may sound like a simple question but I really can't find the answer!
How can I restrict the values entered in a user form. Example - I have a text box set up in a user form that prompts for inputs that will only accept numbers - but I want to restrict that further by only allowing the user to enter a number between 10 and 15. I can't use a list because I need the flexibility of having decimal entries as well (e.g. 10.27, 14.49, etc).
Any ideas?
Hi,
On the 'Activity' sheet I select the date, select the description, and select the category (dependent on the description using indirect) and enter a value. ($ dollar amount)
How do I make the entered values appear automatically :
- on the correct Sheet for the Description - 'EXPENSES' or 'INCOME'
- in the correct columns on the sheet for the category
- and in the correct row on the sheet for the date,
- "add to" if a value already exists in the cell
after they have been hand entered here on the 'Activity' sheet?
I would attach the workbook in case it helps if I could figure out how...?
Grateful for all help!
Synthia
I have seen many different topics that involve deleting a row based on a set condition. However, I am having trouble adjusting their codes for a variable condition.
As you can see in the below picture, there is a list of baseball players and to the right is the name of the "current player". If I click a button, I want to have a code that automatically deletes the entire row that has the same name as the current player. Anyway I can do this? I didn't know how to insert parameters into the code, if that's how you do it.
I have a range of data in say column C4:C15. I would like the highest value to appear green and the lowest value to appear red. However I only want these to trigger when more than two values are entered.
Basically I don't want the format to trigger when only one value is entered. This may be elementary but I'm stuck.
Prevent Duplicate Values Being Entered in a List