Find Column A Of Same Row Anywhere On Row
I typically record macros that need to copy information like a company name from say sheet 2 and paste in a specific cell in sheet 1. As the cursor can be anywhere on a specific row I usually create a column that holds something like zz.. and then in the macro go
Shift + Spacebar to select the line I need to work from then Ctrl + F to find zz.. and that is how I know where the cursor is as a starting point.
How is it possible to have the cursor know how to find a specific point i.e. column A from any specific column on that same particular row?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
- Find Value On Row & Find Last Used Column Before Found Value
- VBA Find First Populated Column In A Row, Starting At Column X
- Find Value In Column & Return Cell On Same Row- Different Column
- Find Last Row In Column
- Find The Last Column In Row
- Find Last Row Reference In A Column
- Find A Value In Column A And Then Make A Copy Of The Whole Row Right Below It
- Find Cell Based On Column And Row
- Find & Return Value Same Row, Different Column
- Find Row Number With Two Column Match
- Find Value In Table Based On Value In Row & Column
- Find Row Number Of Last Non-blank Entry In A Column
- Find Intercepting Cell Of Row & Column
- Find Value In Column & Copy Entire Row
- Find The Maximum Value In One Column And Retreive The Name Of Cell In Corresponding Row
- Find All Cell Values In Column And Delete Row
- Find 1st Empty Cell In Row From A Column
- Find Next Empty Row And Select Cell In Column A
- Find Non-blank Cell In Column Then Copy Row
- Find Value In Column & Copy Insert Row
- Find Duplicates In Column & Combine Onto Same Row
- Find Text & Offset By Found Value Row And Column
- Find Text In Column, Copy Next Row And Paste In New Sheet
- Find Value In Table & Return Column / Row Header
- Search From Every Row Of Column In A Column And Return Row Number
- Report The Value Of An Intersecting Row And Column, Without Numbering The Row And Column
- Find Data In Column Range & Return Cell Same Row But X Columns To Right
- VBA Macro To Find Text, Offset Column/Row & Copy
- Find Text/Value & Use Found Cell, Row, Column In Macro Code
- Highlighting Active Cell's Row, Along With Any Row That Shares Same Value In That Column
- Lookup Row In Column & Heading In Row
- Conditional Format A Row Based On The Value Of The A Column Of The Row
- Pass Row Number Of Last Used Column Row To Variable
- Find All Row Values Selected In Multi Column ListBox & Fill Adjacent Cell
- Find Last Row Containing Value, Then Insert Row After
- Find Within Row And Delete Row
- Automatically Insert Row When Row Value In Column Changes
- Copy From Row In Column To Last Used Row
- Copy The Information From The Row Directly Above The New Row And Paste (values, Formulas, Formats, Etc) Into The New Row
- Find Cell Value Row Number & Use For Column Number
- Find Number Of Column With First <>0 Value In Row X Without Macros
- Identify Button (shape) Row To Insert Row And Delete Row
- Copy All The Rows Until Row 37 And Move It One Row Up After The Selected Row Is Deleted
- Multiple Row, Single Column Cell Blocks Into Single Row, Multiple Column Format
- Look Up In Column A Of "AS" Once It Find That Number I Need It To Return The Number Thats In Column E Of That Row To Sheet "IS"column D
- Find Last Row..
- Find The Last Non Zero Value In A Row
- Match Text In Column Of Another Workbook & Return Nth Column Same Row
- Function To Put In A New Column To Get The Abbreviated Year And Month Of A Previous Column In The Same Row
- Macro - If Cell In Column Is Blank Then Input Text Into Same Row In Another Column
Find Value On Row & Find Last Used Column Before Found Value
Dim ColNo As Byte Dim LastCol As Byte ColNo = Application.WorksheetFunction.Match("Column find", Range("sheet1!A1:Z1"), 0) LastCol = Range("sheet1!b1").End(xlToRight).Column But the below code errors? Dim ColNo As Byte Dim LastCol As Byte ColNo = Application.WorksheetFunction.Match("Column find", Range("sheet1!A1:Z1"), 0) LastCol = Range(Cells(1, ColNo)).End(xlToRight).Column
View Replies!
View Related
Find Value In Column & Return Cell On Same Row- Different Column
I have an excel sheet I am working on and in columns F1:F2000 I have an IF statment, I need to be able to add more "IF"s to it but I will exceed the 1024 char limit. Is there a way I can put this formula into VB as a function called DocumentType() and then in excel F1:F2000 =DocumentType()? Is it as simple as: Function DocumentType() If(...........) End Function
View Replies!
View Related
Find A Value In Column A And Then Make A Copy Of The Whole Row Right Below It
I have the text value "Ball, Red" somewhere in column A. I don't know which row it's in because it will never be in the same row twice. I need a macro to find this value, then, copy that whole row and "insert copied cells" right below that row and change the value in the newly created cell from "Ball, Red" to "Red, Ball". I tried macro recorder to do this and had no luck... Cells.Find(what:="Ball, Red", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Copy Range("A21").Select Selection.Insert Shift:=xlDown Range(Selection, Selection.End(xlToLeft)).Select Range(Selection, Selection.End(xlToLeft)).Select Application.CutCopyMode = False ActiveCell.FormulaR1C1 = "Red, Ball" Range("A22").Select That's is all there is to it on this one.
View Replies!
View Related
Find Cell Based On Column And Row
I have a spreadsheet which has about 100 different SKUs in column A and the inventory for each SKU by period in columns B:Z So for example B would be P1W1 and C would be P2W2, etc what kind of lookup function would I use in VBA to find per say, the value of SKU #: "27017" in P1W2 ? Apart from pivot table.
View Replies!
View Related
Find & Return Value Same Row, Different Column
I would like to use a macro to find a number in a worksheet, other than the worksheet i'm using the macro in. The number - in this case a material code located in Column A - must be entered by the user in an inputbox, and then return (copy&paste?) the value of another cell (the price of the material - in Column D) in the same row. I recorded a macro envoking the find function, but then it only finds the number which I used during the recording. How do I change the code so that the user can input any number, or what code must I write?
View Replies!
View Related
Find Row Number With Two Column Match
I'm trying to do something similar to the Vlookup function (or Index/Match method) but with two or more parameters to match instead of just one. I want to returnn the Row where two columns match the input parameters. Using Vlookup is a problem because it only returns the first one. Is the standard method to us Vlookup for one parameter, then check the second and if it doesn't match reduce the search field, find the next and check the second again etc? That would work but it would be much simpler if there's a 2 parameter function.
View Replies!
View Related
Find Value In Table Based On Value In Row & Column
I have a table where the columns are named: A, B, C, D and E and the lines are named: 1,2,3,4 and 5. All the cells of this table are filled with values. I want the function to return the value on the correspondent cell everytime I type a combination of column and line. For instance if I type "B2" the function would return the value on this position... Actually I am looking for something like a combination of the functions "hlookup" and "vlookup"...
View Replies!
View Related
Find Row Number Of Last Non-blank Entry In A Column
I want to find the Row Number, not necessarily the cell value, of the last non-blank entry in a Column. If the address of this row is found, then that could also be useful. I believe there are some simple Excel functions to do this, maybe involving the X1Up feature. I've searched the threads and haven't found a clear answer this. Below is code that I custom wrote, but its long and tiresome to use. 'The purpose of this sub is to find the last filled row in a column 'Knowing this last row is useful for telling later ' looping operations which row to stop on. 'The logic of this sub is that it will look down a column.........
View Replies!
View Related
Find Value In Column & Copy Entire Row
way to search for a value in a cell (an unique one) using an input box and then if the value is found copying the whole row of the cell onto a new worksheet in the next available row within a table. I am currently using the following archaic codes: x$ = InputBox("Please Enter Catalogue Number") For i = 4 To 500 If Sheet2.Cells(i, 1) = x$ Or Sheet2.Cells(i, 7) = x$ Or Sheet2.Cells(i, 8) = x$ Or Sheet2.Cells(i, 9) = x$ Then Sheet1.Cells(6, 1) = Sheet2.Cells(i, 1) Sheet1.Cells(6, 2) = Sheet2.Cells(i, 2) Sheet1.Cells(6, 3) = Sheet2.Cells(i, 3) Sheet1.Cells(6, 4) = Sheet2.Cells(i, 4) Sheet1.Cells(6, 5) = Sheet2.Cells(i, 5) Sheet1.Cells(6, 6) = Sheet2.Cells(i, 6) End If Next i End Sub this has the problem that i can't fit it to the next available row and have to be specific for each row. it would also be great if i could put a messagebox in cases where the data is not found, basically saying that the item does not exist and if a simple excel Ctrl+F button or something similar could be attached to the msgbox so that the item can be searched and then added to the next available row.
View Replies!
View Related
Find The Maximum Value In One Column And Retreive The Name Of Cell In Corresponding Row
I spent couple of hours trying to figure this out, but without success. Please check the attached example. I need a formula that will find the max value (number of views in English anguage) in the column "I" and display the corresponding "Headline" value in the column "B". In the example it is "Headline 5". I can not change position of the columns, i.e. "B" must remain "B" and "I" must remain "I". I experimented with Index and vlookup but to no success. I have outlook 2003.
View Replies!
View Related
Find 1st Empty Cell In Row From A Column
I am trying to find code that will find the first empty cell in a row and add data in cell left to right. This code is filling all data in the last cell of the row and I am hoping to have it loop through data and fill the first empy cell (M1) and next data placed (m2) and so on Sub Reportdates() Dim Grid As Range, Gridcell Dim Crit1 As Range Dim Crit2 As Range Set Grid = ThisWorkbook.Worksheets("sheet3").Range(" dates") Set Crit1 = ThisWorkbook.Worksheets("Stageing").Range("J1") Set Crit2 = ThisWorkbook.Worksheets("Stageing").Range("K1") For Each Gridcell In Grid If Gridcell.Value >= Crit1 And Gridcell.Value <= Crit2 Then ThisWorkbook.Worksheets("Stageing").Range("M1").End(xlToRight).Offset(0, 0) = Gridcell.Value End If 'Exit For Next Gridcell End Sub
View Replies!
View Related
Find Next Empty Row And Select Cell In Column A
how i can go about finding the next empty row (and select the first cell of that row (column A))? edit: It probably should be noted that there are cells in Columns A through P. There are rows where all and/or just one cell contains data per row. So i cannot use a " lookup" based on a single column.
View Replies!
View Related
Find Non-blank Cell In Column Then Copy Row
Basically this is what I want to do: 1. Search a specific column (Column 21/U) for non-blank values in Worksheet 1 2. Copy the entire row containing the non-blank values 3. Paste these rows into Worksheet 2. Repeat steps 1-3 an additional 2 times, where Worksheet 1 is always searched but one more column to the right (ex. Column 22/V) is the target column for the search, then the rows are pasted into the next Worksheet (for ex. Worksheet 3)
View Replies!
View Related
Find Value In Column & Copy Insert Row
I have a macro that was working fine until I added a new column to my active sheet. Now it fails with a run time error 1004, insert method of class failed. The code is as follows: Private Sub UpdatePart_Click() Dim S As String Dim r As Excel. Range Range("A2").Activate S = InputBox("Enter the part no. you wish to update") On Error Resume Next If S = "" Then 'Exit Sub 'If StrPtr(S) = 0 Then MsgBox "Update Cancelled" Else Set r = Columns(1). Find(What:=S, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False)...............
View Replies!
View Related
Find Duplicates In Column & Combine Onto Same Row
I have a unique id in column A on a sheet with 20,000 contacts. I need a VBA script to loop through the worksheet and when it sees that there is a duplicate in column A, it needs to take the data from columns B, C, and D of that duplcate and copy them to the first blank cell at the end of the original record. Then it needs to delete the row that contained the duplicate that it just copied. I have searched and found parts of code that will do some of these, but I can't get anything to work, I don't know VB enough.
View Replies!
View Related
Find Text & Offset By Found Value Row And Column
I'm writing some code where I need to know the column in which a specifc text string occurs. Because of the nature of the sheet, the string will only appear in one column, but that could be in almost any column on the worksheet. For example say the text string is "Year 1", I need to find the column with this string, and then offset down to a predetermined row, or offset over to the appropriate column (something like below). With Selection .Offset(0, x).Select If List.Selected(0) = True Then y = i - 1 With Selection .Value = Salary * Inflation1 ^ y End With Else
View Replies!
View Related
Find Text In Column, Copy Next Row And Paste In New Sheet
Essentially, I have 2 Sheets: "SheetWSS" = data to be copied "SheetWSD" = destination of copied data. Below is a sample of the data in "SheetWSS" ----------A------------------------B-------------------------C 1------Trade ID -------Description---------System no. 2--------579----------------Loan ---------------------- 7 3--------580----------------Deposit---------------------22 4--------702----------------Deposit--------------------- 11 5--------703----------------Loan ----------------------- 58 6--------732 ---------------Loan------------------------66 7--------733----------------Deposit-------------------- 99 etc...(no more than 10000) Now, an explanation of the data: 1) I work for a small bank (CORP) that takes deposits and gives loan. 2) CORP books these trades using only system no. 7 and 11; other system nos. belong to customers. 3) When a single trade is booked, the 2 sides of the transaction is recorded (by Trade IDs) . E.g rows 2 and 3 relates to one trade. So if CORP loans money with system no.7 to CUSTB, who uses system no.22, it shows for CORP a loan and for CUSTB, a deposit. 4) Everyday, the data in "SheetWSS" is updated with a different number of rows from previous, but the number of columns remain the same. So, here's what i'ld like the macro to do: 1) Go into Column C, find system no.7 and 11. 2) For each 7 and 11 found, Copy the next row . So if for e.g, system no.11 was found in C4, i want the ENTIRE ROW 5 to be copied. 3) Paste the entire next row in "SheetWSD" until we have a list of all opposing sides of the same transactions initiated by CORP.
View Replies!
View Related
Find Value In Table & Return Column / Row Header
I am having trouble with getting a value (which is the row and column value) from a set of numbers. I have attached an example table to try and make things clearer. What I have is a table with a set of Row Headers, and Columns Headers all numeric. e.g Columns headed 1, 2, 3, 4, Rows 30, 40, 50 etc. I want to find the 1st occurrence of a value e.g. 1.0 in the table (by 1st Up mean closest to top left), and then give me the value of the Row and Column Header that corresponds to that. So for the example attached, I want to get the row Value 200 and Column 6 from finding the 1st occurrence of the number 1. I have tried various combinations of index and Match etc. But I can't get my head around the fact that the position of the 1st no. 1.0 can change, therefore I can't use any releative positions etc.
View Replies!
View Related
Report The Value Of An Intersecting Row And Column, Without Numbering The Row And Column
# STUDENTS THAT GOT 100% IN EACH SUBJECT IN EACH SCHOOLKKVRockfortCampionENGLISH232013MATHS382518PHYSICS422515CHEMISTRY483020BIOLOGY503523 Consider the above table. Ca someone help me understand how to report the value of the # of students that got 100% (output) in a given school (input 1), and given subject (input 2). In other words, if the inputs are the following: Input Cell 1: Rockfort Input Cell 2: Pysics Then, Output Cell should report: 25 I know one option is to use the INDEX function, but with index function, I have to provide Row_Num & Col_Num as inputs. That doesn't fit my example above, as my inputs are specific values from the leading row and the leading column of the array in question.
View Replies!
View Related
Find Data In Column Range & Return Cell Same Row But X Columns To Right
i have is 3 sheets in the same excel document. Sheet 1 is the mater sheet, which is a compilation of sheets 2 and 3, however the sheet layouts are different. The sheets consist of a list of names and details. Sheet 1 has all the names in the list, however sheet 2 and 3 only have partial lists that are in a different order from the original list. The details listed next to the names in sheets 2 and 3 are different and hence a straight forward row copy and paste will not work. What i need is to write a vba script that can take the name from the master list, search sheets 2 and 3 for the name and lookup the variables placed in next to the name, then update the master sheet accordingly, then continue to the next name on the master sheet and do the update again, and so on until all is updated. I have already thought about using lookup functions in excel however there is 1000 names on the list and around 60 details so it would be messy.
View Replies!
View Related
VBA Macro To Find Text, Offset Column/Row & Copy
I am in the process of writing a VBA code(I should I am fairly new to this code writing!!!).What I need to be able to do is below.(enclosed please find a output in an xls file) What I should be able to do is below: 1.Find the text "Cash(No Listing)(Monthly)" 2. Offset to the 13th Column after that 3.Select the value in this column ,copy the value 4.Go to a row above and move one column to the left i.e.offset (-1,-1) and move 12 column backwards i.e.offset(0,-12) 5.Copy the value in 3 above to this entire range 6.Repeat this process for the entire file My code is as below.Let me know where am I making a mistake. Just to let you know that this code performs the job well for the first entry i.e in the yellow makde area and doesn't do the job for any further entries .Llooks like I have some problem with the loop but not sure as to whats happening!
View Replies!
View Related
Find Text/Value & Use Found Cell, Row, Column In Macro Code
I am trying to clean up and simplify my macros by compartmentalizing frequently repeated commands. I like to search for text in column headings and define the cell containing it as a range that I can later use .column or .row commands on, so my macros are a bit more flexible. The code I currently use for this is Dim XColumn As Range ‘the cell containing the text “X” Cells.Select Selection.Find(What:="X", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Set XColumn = ActiveCell I would like to be able to create a Macro (possibly name FindSetCell()) that will accept arguments and achieve the results of the above code in other macros I think the command might look something like FindSetCell(“text to be searched for”,”name of newly Defined Range”) But I have not figured out how to code it
View Replies!
View Related
Highlighting Active Cell's Row, Along With Any Row That Shares Same Value In That Column
Is it possible to click on a cell in column C, and have the wishlist below happen: That active cell's row is hightlighted. Any cell in that column that has the same value as active cell is also highlighted. Plus, any cell in another sheet that has that value it's row is highlighted too. Example: I click on C5 in Sheet 2 its value is 45000789 it row is highlighted, this value also appears in C3 in the same sheet, so it's row is highlighted as well. Plus, in sheet 1 in C10 this value appears and it's row is highlighted as well. When any of the values are clicked again the highlight is removed from all parties.
View Replies!
View Related
Lookup Row In Column & Heading In Row
I'm trying to enter info in a cell based on what is entered in two other cells. So I have a dropdown box for the species on another sheet as well as a dropdown box for rail sizes. Then I have to crossreference them to come up with an upcharge number. Sorry for my basic lingo. I hope it's understandable.
View Replies!
View Related
Pass Row Number Of Last Used Column Row To Variable
This line in my code is causing an invalid qualifer error message: lngNew = wsNew. Range("B65536").End(xlUp).Row.Offset(1, 0) Option Explicit Sub Disney_DumpData() Dim wbBook As Workbook Dim wbNew As Workbook Dim ws As Worksheet Dim wsNew As Worksheet Dim rng As Range Dim rngNew As Range Dim rngUnit As Range Dim rngUnitPaste As Range Dim lngNew As Long Dim Cnt As Integer Application. ScreenUpdating = False Application.Calculation = xlCalculationManual Application.DisplayAlerts = False Set wbBook = ThisWorkbook Cnt = 0 'Dump To New File '/Define new workbook Set wbNew = Application.Workbooks.Add.....................
View Replies!
View Related
Find All Row Values Selected In Multi Column ListBox & Fill Adjacent Cell
I have a listbox that has row and columns. The rows are combinations of options and the columns are Additives. After selecting a row in Listbox1, (first column are names) i would like the value of the second column to goto a specific area.... find that value and in the cell to the right of it place a "Y". The "Y" would indicate that "yes" it was part of the selection row of the listbox. Same for third column, forth, fifth and sixth. The result from the listbox is a number of Y's and N's in the result page. Then making all that were not part of selected line and equal to "N" to hide row (height = to zero). Listbox and expected result are in attached example worksheet. The attached does show the need much better then I can explain it.
View Replies!
View Related
Find Last Row Containing Value, Then Insert Row After
I am creating a worksheet of contacts and the date and time that I phone them, along with their current "status" in our company. I have created a form and have got it to do the insert of new data that I input, BUT What I would really like is enter a "client number" (which is unique) and have it search my table for any record(s) with that client number, and then show me the last record that matches the client number, (this can all be done from within my form) then If I click on the "insert" command button, I want it to insert a new row after the current row and move my form data in the form into the new row which will include a date and time. So, To summarize.....I need 2 similar subroutines. LOOKUP ----- I need to have my form scan down the data for a match in a particular (pre-sorted) column, stopping at the last line that matches, then display the data or display nothing is there is no match. INSERT ----- I need to have the form scan down the data for a match in a particular (pre-sorted) column, stopping at the last line that matches and then insert a blank row here and move my data into it.
View Replies!
View Related
Copy From Row In Column To Last Used Row
i hav a file with over 2000+ rows of data..i'd only like to copy out F7:F77 only..However the length of information in the reticle data (refer sample) may varies..so from cell F7 i found the last used cell using --> range("F7").End(xldown).Select how do i select the whole column F7:F77 from there so i can copy it out?
View Replies!
View Related
Copy The Information From The Row Directly Above The New Row And Paste (values, Formulas, Formats, Etc) Into The New Row
1. In whatever cell is selected when the macro is run, enter a new row. 2. Copy the information from the row directly above the new row and paste (values, formulas, formats, etc) into the new row. 3. Return to column P in the new row, i.e if the new row is row 11, then return to P11, for row 12 return to P12, etc. I have tried recording the macro but because it is hard coded to specific rows, its not working. I have attached a sample copy of the sheet (had to zip due to the size of the file).
View Replies!
View Related
Find Cell Value Row Number & Use For Column Number
to update these values via a form in this sheet. I can find the correct row to be edited by entering a value from column A and B. The problem is if I want display the values of that row first and then change it. If I want to change row 10 data how can I bring back the value in ROW 3 AND THE COLUMN VALUE? The next step would be to do the actual update if I want to change ROW 10 to "Ooi" and a sales value of 200? This is what I have done so far: Dim myRows As Integer With Sheets("Mrt") 'Retrieve history information for row For myRows = 4 To 49 If comboxDay.Text = Range("A" & myRows).Value And textboxdescription.Text = Range("B" & myRows).Value Then textboxbedrag.Text = Range("C" & myRows).Value chkBTW_Ja.Value = Range("D" & myRows).Value txtNota.Text = Range("S" & myRows).Value End If Next End With Picture attached to show how sheet looks like.
View Replies!
View Related
Identify Button (shape) Row To Insert Row And Delete Row
I have a button (group containing and add and delete button). I want to identify the row (position of shape/button calling the macro) to enable inserting a new row (1 row down from current row). Then do the same to delete a row (position of shape/button calling the macro) to enable deletion of selected row. This will allow me to add/insert rows by the button located at that row The problem i have is getting the row property (row position of the button eg. TopLeftCell.Row) of the add button. The add button (RowBtnAdd) is a shape within a group (BtnGrp) I also note that when a group is copied, it has the same shape name as that copied. I want to keep the add and delete shape within the group (BtnGrp). I do not want to select a cell or row or enter a row number to delete etc. refer to sample workbook attached. Currently only has one record row.
View Replies!
View Related
Find Last Row..
I have a worksheet that has data in column C. The data is separated by blank rows. How can I find the last row in that column with data. Following function stops at the first blank cell at the end of first block of data. .End(xlDown).Row Is there a way to make the code look at rest of the column and find the last row with data?
View Replies!
View Related
Find The Last Non Zero Value In A Row
I'm trying to find the last non zero value in a row. My data looks like this: # J F M A M A 4 5 5 5 5 B 0 0 3 3 3 C 0 0 0 0 2 D 0 0 3 3 0 I want to compare the earliest value to the latest (e.g. for A, that would mean 4-5 = -1; for B that would mean 3-3=0, etc). I have a formula that finds the first non zero value in the row, but have been unsuccessful in writing one that finds the "last" non zero value in the row.
View Replies!
View Related
Match Text In Column Of Another Workbook & Return Nth Column Same Row
I have two excel files. File #1 is a varying length and has 4 columns with ID #s in Column A. File #2 is a two column file that contains a list of ID #s in column A AND modified ID#s in column B. I need to match the ID #s in column A from file# 1 to the list in column A of file#2 then replace ALL instances of the matching ID #s in column A of file#1, with the values found in column B of file #2. I've tried using the substitute function but I could only replace one found ID at a time.
View Replies!
View Related
Macro - If Cell In Column Is Blank Then Input Text Into Same Row In Another Column
I am looking for a Macro that will search a column for blank cells, and when one is found will add text to the same row in another column. For example: The below is a spreadsheet. I am trying to find something that will search through column "C" in this case and add text (of my choice) to Column "A" if the cell is Blank. So Since cell C1 is Blank then Type "ERROR" is cell A1. A B C D E 1 X X X X 2 X X X X 3 X X X X X 4 X X X X 5 X X X X
View Replies!
View Related
|
TRACKER
