This works, UNLESS "My Column Header" is the last column, or second to last column, then it jumps left two columns, instead of landing on the correct column.
The purpose of this script is to select a cell directly in that column that I was searching for.
I'm looking for a formula that will return the column header (a date) of the first instance of a number greater than 0. For example if columns A through S had dates as in row 1 (header row), and in row 2, every column contained a 0 up until column P, I would want the date (Row 1, Column P) returned? I think this might be a sort of index/match formula, but I am not very familiar with these.
I need my macros to search for the word "Cancel" or "Cancelled" in columns "T" and "U". Once found, I need the macros to make that entire row an opaque shading.
There will be other wording in these cells that contain "Cancel" or "Cancelled". Is it possible for the macros to search in the sentence and find the words "Cancel" or "Cancelled"
Right now the code below reference AI on sheet BOM. However, I need it to be either referenced by being the last filled row on sheet BOM or by having the word "rounded" on row 4 --what which over column on row 4 that has the word "rounded".
Current code:
Range("J2").Select If Sheets("BOM").Range("C4") = "" Then ActiveCell.FormulaR1C1 = "=BOM!R[3]C[25]" Else ActiveCell.FormulaR1C1 = "=BOM!R[4]C[25]" End If
I'd like to tell Excel that anytime it finds the text "ABC" anywhere in any cell in column B but doesn't have any data in column A, to delete the entire row.
Anyways, the issue is that when I have some cells selected then use the text-to-columns, it works fine.. but when I select an entire column, it "acts a fool"...
I made this video to show the effect on my computer.
I have a column of cells (Column I2:I1063) with zip codes in it and I want to keep the row if the zip code matches one on the list in a column B2:B100 on a separate sheet (Sheet1).
I have the following code that enters data from a user form, the problem is that the textbox (Locker) data will not validate when entered into worksheet.
Private Sub cmdEdit_Click() Dim rownum As Integer rownum = 2 'Prompt user with message box asking for input in both text boxes If Me.txtNumber = vbNullString Then response = MsgBox("Please enter a Work Number", vbInformation) Me.txtNumber.SetFocus Else ' Insert the work no., driver, locker, keys issued & keys On hand ActiveCell = Me.txtNumber.Value ActiveCell. Offset(0, 1) = Me.txtLocker.Value ActiveCell.Offset(0, 2) = Me.txtIssued.Value ActiveCell.Offset(0, 3) = Me.txtOnHand.Value................
I have a spreadsheet for payroll. The last column is for net pay. I enter this by hand when I get it back from the payroll tech. There are no formulas in this column. When done entering these figures, I click on "save". Then I close the file. From past experience with this sprdsht, I have found that it doesn't always save this column. It saves all the other info. I have entered in the sprdsht, but not this column. So, I have to re-enter everything in this column and "save" again. Close the sheet, then re-open it to be sure it got saved. Why won't it save this column of info. the first time?
I have titles in column A and multiple codes per title in column B.
I want all the codes for a single title copied onto another sheet.
I can't use =B1 as the sheet gets updated every week and the amount of codes per title changes.
I was thinking using lookup but the majority of column A is blank and I don't know how to make it look in the row above if blank, or if that is even possible.
Another option would be to look for the title in column A then copy column B until the text "Group Total" which always appears at the end of a titles codes.
I have a list of peoples first and last that I am trying to import into another application. My problem is that the application wants the first names in column A and the last names in column B. Right now my excel has the first and last names in the A column. I would just copy and paste, but there are 2,600! I just want to move the last word in column A to column B...
I am an intermediate MS Excel user and I have a question for those of you who are more savy. I am trying to figure out if it is possible to populate a field in Excel by reading the footer of a MS Word document.
I have a file with a lot of numbers, but one column with single digits. These digits have a cooresponding model name. I want to convert them all to their model name. There are only 4 model names. I tried a nested IF statement, but felt this wasn't working properly or was not the proper formula choice.
A Find/Replace would work, but it picks up the single digits elsewhere in the sheet. I realize i could copy/paste my column to a new sheet and from there convert/paste, but I am trying to get better at Excel.
I want a formula to scan column B for a given word. One version of the formula will look for the word "ACAD", the other "GOV". If it shows ACAD anywhere in column B, I want to put ACAD in column D.
So, I have two columns on a sheet that all contain drop down boxes for various information. We'll refer to them as column 1 and column 2.
In column 3, I want to have the highest instances of those words sorted with the highest on top, and downward from there, along with the number of times it appears in either column 1 or 2. (And I want the sorting to be dynamic, i.e. when I change what's in column 1 or 2, it will re-rank them according to highest number)
i.e.
Column1 Column2 Column3 (Column4-#) Bob Tom Bob 5 Joe Bob Tom 2 Bob Joe 1 Tom Bob Bob
I have the drop downs and what not for the 1st 2 columns, I just need to know how to make 3 & 4 happen.
I just had an employee come to me and ask to take a look at his Excel spreadsheet. One of the columns auto filled the word General all the way down. I tried to do a find and replace but it did not work. Then I tried to just delete the cell and noticed that the text disappears when you click into the cell. This "ghost" text is frustrating me and I can not get it removed
I have a sheet called 'TimeRecorded' which will contain lots of rows of data.
If a row contains 'invoice' in column H, then the data in that row, preferably as far as column H, should be moved to the next blank row in a sheet called 'Archived'.
I would like the macro to move every row that contains 'Invoice' in column H to be moved.
On the data sheet I attached you can see easily what I am trying to do:
The macro should do something like this basically:
Column A there is a entry like "L110E (CST_PRG-Wheel Loaders-E series models)"
Lets say we have 10.000 entries more or less like this.
Macro should do this: * Take first word for example in this case "L110E" and copy into column D same row. * Take second word's second part in this case only "PRG" and copy into column B same row. * Take the 3rd word between - - in this case only "Wheel Loaders" and copy into column C.
I have a database in excel, here's some sample data.
When they click the print button in Cell A2, up comes my form
When the print tags button is pressed, my secondary sheet is populated with the cell they clicked on
Now it's using a font, calibri 11, which isn't proportional but I was wondering if there's a way in VBA to "auto" detect the max width and place words on the next row accordingly (like a word wrap). Here's what I need it to look like:
Here's my existing code to place the comments as is:
How to make information gathering easier. So I have a spreadsheet with information in one tab and Graphs & tables in another. I am trying to count how many times a word appears in my last column (the word is "HM - GM") but I only want to count how many times that appears in the month of Jul (The July column is my first column, it shows as "Jul-13" but when you click on the column it appears as 01/07/2013). I have tried a few =COUNTIFS formulas I found around the site, but none seem to work for me. I am trying to get the counted information into a table so it will show how many 'HM - GM' were in Jul-13.