Serach One Column And Enter Text In A Differnt Colunm If Criteria Is Met.
Nov 19, 2008
In worksheet "Details" search down column "A" looking for any text/numbers. If there is something entered in the cell then look at column "M" for the same row and if that cell is empty inset "0%" in the cell.
Example:
Cell "A1" contains 12345. Cell "M1" is blank. The macro would inset 0% in "M1".
Cell "A2" contains 54321. Cell "M2" contain 40%. The Macro does not modify that row.
Cell "A3" is blank. The macro does not modify that row.
Cell "A4" contain 65478. Cell "M4" is blank. The macro would inset 0% in "M4".
Im trying to write a marco that will look in colum E and find criteria "a", then offset (2,1) and copy the activecell and the one below it to a1:a2, then return to where it was and offset (0,1) and then copy the active cell and the one below it to a4:a5.
after this is accomplished i need it to return to column E and start the process again for "critera b" paste the result to a7:a8 and a10:a11
I know folks usally post examples of the there code for other to take a peek at however I only know bits and pieces of the process and im not sure how to tie it all together...I was hoping someone could help me get a good start....thanks
I've got two columns with data. The first is text, and the second is numbers. So I want to be able to enter a certain criteria that would be contained in the text, and have excel return a list of the rows of text that contain that criteria and that have the highest 3 values in the corresponding column. I can use multiple cells to do this if need be (i.e. one cell for the text with the highest value, one for the second highest value, and a third for the next highest value).
My data is in colunm set #1. I want to create from the data set in column set 1 the data set shown in colunm set #2. I want to automate the process. The program needs to regognize if a name appears only once or more than once. If it appears more than once the data needs to be merged as I highlighted from yellow to green.
I want to create Name to include data in A101, C101, E101, G101, I101, K101, M101 and O101. How do I do it? I tried to hold ctrl, then click on each cell above, type name but it did not take.
A B X1283.786 Y1684.379 Z1719.013 X10745.013 Y10860.668
i want excel to work out the total for x y and z. however i have about 100 different things x y and z could be and its a long list so an automatic way would be great.
I have an spreadsheet that has a colunm of numbers. I have three totals (values-no formula) that make up the total of that column. But i need to know which numbers make up each of those three totals. I was able to track one of the total but it was too time consuming. I know there are probably several different ways in wich this number can be add up. Is there a way to do this with a macro?
I have my students down the far left column (30 rows) and along the top for each worksheet is the criteria which they must be able to do. If my in row 2 completes the criteria text above in column 5 for example, then I input a 3 which then adds the points and works out their sub level scores. However I am now in need of it being able copy the criteria above if a student on any row has a T(for target) in that box. I would then like that criteria to be copied to a master sheet which displays their name down the side and all the targets they have for that subject in the next column, so that they can be referenced for their report summary worksheet.
The following code works like a dream for me, but if was to enter the wrong letter, not "N" or "R" and i tried to delete it, a debug message appears?
Is there a way to allow any letters to be deleted?
Here is my code
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 17 Then With Range("C" & Target.Row & ":R" & Target.Row).Interior Select Case Target.Value Case "R": .Color = RGB(184, 204, 228) Case "N": .Color = RGB(120, 120, 120) Case Else: .Color = RGB(255, 255, 255) End Select End With With Target.Font Select Case Target.Value Case "R": .Color = RGB(184, 204, 228) Case "N": .Color = RGB(120, 120, 120) Case Else: .Color = RGB(0, 0, 0) End Select End With End If End Sub
If given columns B and C, is there a VBA code that will look to those columns and auto-enter the payments across the week matrix based on that criteria?
This formula allows me to find the lowest value in column U where column N contains the text "NO".
{=MIN(IF($N$2:$N$10000="NO",$U$2:$U$10000))}
I want to add another condition so that the formula only returns the lowest value in column U where (i) column N contains the text "NO" and also (ii) column F contains the text "YES".
need a formula to calculate the total number of x's in one column (column B, C, E are training types= x) where the corresponding column date falls within a date range. It’s to total each type of training done for each month. I have 3 training type columns and a cell that calculates the total number of trainings for the each month:=COUNTIF(F2:F100,">="&DATE(2008,2,1))-COUNTIF(F3:F200,">="&DATE(2008,2,31)). So now I just need it broken down by training type per month. How many x's in each column for February as an example.
how to make a certain type of date automate. It's kind of hard to explain, but basically, I'd like to make it so that when I enter a date in one column, another column will automatically populate with the 1st of the next month. For example:
If I enter 4/26/2009 in the 1st column, column 2 will read: 5/1/2009 If I enter 1/19/2008 .................................................. 2/1/2008
Also, it's very important that if the FIRST date is already the first of the month, then the second column will read the same. For instance: If I enter 3/1/2009 in the first colum, the second column will ALSO read 3/1/2009.
I am looking for a way of creating the following conditioned concatenation.
I have two tables, let's call them "summary" and "detailed".
The "detailed" table is something like the following:
ID VOL
001 01
001 05
[code]....
The "summary" table below gets info from the "detailed" table. The 'ID'is now unique. I'm looking for a formula on the 'VOL (concatenated)' column cells it should get all rows from the "detailed" table with the same ID and then concatenate the 'VOL' column results, comma separated:
ID (unique) VOL (concatenated)
001 V01, V03, V05
002 V01, V04
003 V06
PS: I have people using this table with office 2003, so compatibility is necessary...
I want to enter any thing in column (A) and then the date & time automaticaly put in column (B) enter any thing in (A1), the date & time entered in (B1) automaticaly enter any thing in (A2), the date & time entered in (B2) automaticaly
i attach the testing2.xls attachment here. from the sheet 1 "original", how to copy from 1 column, column"B" and then paste to column "A" by clicking function "alt + enter" at the same row but different row in the same cell. Output result can refer to the sheet 2 "output".
2. Find the range of the "Customer Number" column (bottom-most cell with data)
3. Find the column named "Date Shipped"
4. If there are any NON-Blank cells in the column named "Date Shipped", put the word "Sent" in the "Status" column (also needs to be found by name). This macro should stop when it is equal to the bottom-most cell in the "Customer Number" column.
I have manually set all row heights to 12.75 to make sure they are the same. In these rows I have a comments box and when the end of the cell is reached I use alt&enter to continue writing underneath. Seems the comments cell has stopped re-sizing.
how can i define in code, that my code will start after pressing "enter"? i have textbox, i write something and i have a code. I want only launch my code after pressing enter.
When I click on a cell to enter text, a new little text window pops up inside the cell and doesn't allow me to enter text. No matter where I click in the cell another little text window appears. I also can't delete the text in the cell because the little text window pops up again and again.
I'm trying to add an enter space to text with the combination of a loop and an array, but I cannot find the right combination so that the final result appears as so:
ArrayItem Desired Text or via excel =NamedRange&" Desired Text"
Here is the code for the loop, trying to add the appendage to the first item after the if.
I have text that when you push enter it goes to the next line and when you push tab it goes 5 spaces to the right the problem is...
When i have a lot of data it goes out of range and not all of the text is shown. I want to limit what is written to the size of the text box no matter the size or type the font is you can only type where you can see inside the textbox.
I need to create a form that if you were to enter a name in the text box it would fill all the information across that row into other boxes on the form. Basicly if I type John Doe in the text box it would look in col A for John Doe and then put whats in the cells on that row into different boxes on my form. I have tried searching but I have had no luck.
