Compare And Search Columns For Text?
I recently posted a similar thread which was very well supported but I couldn’t get a solution because my requirements were not clear enough. I would like to try again with a slightly easier and clearer requirement.
I would like a spreadsheet that compares and searches columns for text and returns true if a duplicate is found.
It is similar to a lottery checker except the lines being checked could be a string instead of a single character.
I have attached a spreadsheet which helps explain what I’m trying to achieve.
Basically, a user can sequentially enter a single character to cells F1:F5. These values are then compared to columns A:C. If one of the columns contain the values in column F then return true to G1.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Search Compare Text In Two Cells
I have one sheet and i want to compare the first word in the column "D". If the first word of D2, is the same than the first word of D3, i want to copy to another sheet and after the copy, insert 2 blank rows... if it's different, i want to copy and insert 3 blank rows Maybe it's better to attach the file. In the first sheet, you'll see a little part of the real sheet, and the second sheet is the example of what results i want to obtain with code...
View Replies!
View Related
Compare Two Columns, Text To Date
I have two columns, salesman and date. This workbook tracks quotes by salesman. I need to know how many quotes for each salesman by the month. So what I need to know is how quotes salesman 'a' had in January and February and so on. I have several worksheets in this workbook that are all formatted the same.
View Replies!
View Related
Macro To Compare The Columns Text
macro to compare 4 columns of text (first and last names) then add a checkmark in separate columns if they match and don't match? For example I have this kind of data to compare and the results required: Sheet 1 Last Name First Name Smith Mike Johnson Bruce Hendrick Fred Shaffer Kerry Sheet 2 Last Name First Name Match No Match Klee Pierre X Verge Kerry X Smith Mike X Wright David X Hendrick Fred X I need the macro to mark an X in the Match column if the first and last names match only and if they do not match exactly a X in the No Match column.
View Replies!
View Related
Compare 2 Columns For Numbers In Mixed Text & Numbers
I need to compare two colums by number decription for example m344 in one column and fsh344-1 in another. All I want to match is 344. In column a I want to indcate the match by placing an X by each match. View my attachment for reference. I don't know if it makes a difference but the columns are centered in my original spreadsheet.
View Replies!
View Related
Counting Formula (compare Values In 2 Separate Columns To See How Many Times The Same Value Appears In Both Columns)
I'm trying to compare values in 2 separate columns to see how many times the same value appears in both columns. Ideally I would be able to insert a range function to compare the values in the column "ID 1" against the values in column "ID 2" and return the count of times that a value appears in both columns. For example 2122, 1112 and 1718 appear in both columns and I would like the formula to return a count of 3. ID 1ID 2 12342122 45671112 89101718 11122678 13144544 15162324 17189987 19201215 21221928 1976 2576 2345 4678 In my actual project I'm comparing 2 columns in the same worksheet. The column are column B with data in cells B2:B10266 against column C with data in cells C2:C18560.
View Replies!
View Related
Search And Compare Cell Values In Different Spreadsheets
I have two worksheets with products that I need to compare. Each product has a code and a product name in the following format: Column A has the product code and column D the product name,for example: ColumnA: AM1BL15X ColumnD: AGLO MEL BLANCO 1C 15MM 215X244 Both sheets *should* have the same data in them but there are 4000 products that need to have their description verified.So I need to go down each row on Sheet1 , extract the product code from Sheet1.ColumnA and the product name from Sheet1.ColumnD. Then do a search on Sheet2 for the product code (Sheet2.ColumnA) and verify that the product description on sheet2 (Sheet2.ColumnD) is the same as in Sheet1.ColumnD. If it matches,everything is OK. If not there is something wrong. So I´m thinking that maybe the product codes that dont have matching descriptions could be entered in to a separate worksheet so that someone can check it later. I´ve been reading around and found these code samples from this site [url]: Dim rng1 as Range, i as Long Dim cell as Range With worksheet("Sheet1") set rng1 = .Range(.Cells(1,1),.Cells(1,1).End(xldown)) End With i = 0 for each cell in rng1 if cell.Value worksheets("Sheet2") .Range("A1").Offset(i,0).Value Then ' do what - they don't match else ' do what - they match End if i = i + 1 Next I´ve been trying to make some changes but I dont quite know how to get this working to do what I want and I only get errors.
View Replies!
View Related
Search And Compare Cell Values In 2 Different Spreadsheets
I have two worksheets with products that I need to compare. Each product has a code and a product name in the following format: Column A has the product code and column D the product name,for example: ColumnA : AM1BL15X ColumnD: AGLO MEL BLANCO 1C 15MM 215X244 Both sheets *should* have the same data in them but there are 4000 products that need to have their description verified.So I need to go down each row on Sheet1 , extract the product code from Sheet1.ColumnA and the product name from Sheet1.ColumnD. Then do a search on Sheet2 for the product code (Sheet2.ColumnA) and verify that the product description on sheet2 (Sheet2.ColumnD) is the same as in Sheet1.ColumnD. If it matches,everything is OK. If not there is something wrong. So I´m thinking that maybe the product codes that dont have matching descriptions could be entered in to a separate worksheet so that someone can check it later. I´ve been reading around and found these code samples from this site ...
View Replies!
View Related
Search Compare And Retrieve Date For A Specific Item
I am trying to make a summary from a table showing the newest value available for a set of items(1,2,3,4), this is according to an investigation date the summary table shoul display only the values for the investigation date, but if there are no values for the investigation date, them should take the previous recent date from the investigation date, and if there is not value at all, then shown N/A I am attaching the excel sheet for a better ilustration of the problem I tryed a combination of formulas that I tooked from other threads but is not working properly.
View Replies!
View Related
Search And Compare" Function For A Row That Contains Two Specific Values
I'm looking for a function (or combination of functions) that will essentially search for a row that contains two specific values (in two different cells), then grabs a value from another cell in the same row to use in a calculation. I don't know... that probably doesn't make any sense, and maybe there's no way to get it done. If so, it would save me hours. Couldn't see a way to attch an example file to my post, otherwise I could probably describe it a bit clearer.
View Replies!
View Related
Excel Text Search Through Different Types Of Text And Action Based On Text
1. Search an excel sheet "column" for a particular type of text and insert values based on that text (if found) in another column. e.g I have column A1 to A10 with different types of text. I would like to search for the keyword "Risk is high" OR "Risk=High" for each cell in the column and insert a "1" if found beside it's corresponding "B" column. If not found, I would like to insert a "0". So, if the text "Risk is high" OR "Risk=High" was only found in A6, I would like B6 to be "1". Rest of the values in the B column would be "0's", since the text was not found in any of the other cells.
View Replies!
View Related
Compare Columns
I have two diffrent sets of columns of data on a spreadsheet one column set is A,B the other is D,E I want a formula or makro that will check columns A,B and compare it to D,E and if it finds a match will paste it in G,H is that possible and how would I do this?
View Replies!
View Related
How To Compare 2 Columns
i've check the other threads on how to compare two columns but for some reason it is still not working for me. I have 2 columns. Column A is the master column and column B is the comparing list. If the company that is listed in Column B (Anywhere in column B) matches exactly with the company name in column A, I would like it to say "check" in column C.
View Replies!
View Related
Compare Value In Columns
I have two worksheets but have a same column named "Admin No.". I will need to compare the 2 "admin no." column. Example: Worksheet 1 Admin No.Name 1111Ali 2222James 3333Janet 4444Lihua 5555Ting Ting 6666Jasmine Worksheet 2 Admin No.Name 1100Alvin 2200John 3300Mavis 4411Haoyi 5555Ting Ting 6677Jason I will ike to compare both "admin no." column and when worksheet 1 5555 can be find in worksheet 2, it will return True. 6666 cannot find in worksheet 2 then it will return false.
View Replies!
View Related
Compare Columns Within A Range
i'm trying to do some analyzing on an excel sheet and was seeing if there was a function that I could use to speed this up. So in the file... I want to Group what's in Column A So the 1's together and the 2's together... Once that is selected I want to know what the largest number in Column C is... So if the function can select 1 in column A then tell me that 10 is the biggest number in Column C....
View Replies!
View Related
Vlookup - Compare Two Columns
I need a Vlookup to look at two columns when searching. here is an example: Sheet 1 is my report grid to hand out to the employees, A1 has a drop-down list with my employees names and A2 one for the month, when you click an employee name the vlookup formula fills in the information from sheet 2 (data sheet). Sheet 2 has data like: Col 1= Month, col 2=employee L-name, col 3= production etc... currently the vlookup formula messes up because the employee name is in there multiple times because of the months column, i have to delete all months except the one i need. formula is: =vlookup(A1,'sheet2'!,B:C,2,false) this formula will pull the data in sheet two column 3 (production) for the employee that matches. how can i make it compare first to col 1 (month) and then col 2 (employee).
View Replies!
View Related
Compare All Columns To First And Update
I receive hundreds of excels which I combine into one sheet for input into a program (which I don't know much about). The combined sheet contains 2 columns repeated with different information. For instance Column A is Category, Column B is Dollar Amount, Column C is Category, Column D is Dollar Amount and so on. I then start with Column A and compare it to Column C to make sure the categories match. If C is a new category (not listed in Column A) I shift columns A and B down one and add the new category to Column A. This updates my master list in column A but also maintain the format and correct dollar amount that was listed in Column B. Then I move to Column E and compare it to A using the same logic. I repeat this process throughout hundreds of columns. I then delete all the category columns and am left with Column A as a master category list and all the dollar amounts in the correct location for all excels that have been sent in. I'm hoping someone here knows a faster way for me to do this using VB or VBA for Excel or a Macro. I've tried a few things I've found on these forums to no avail, and I'm not an expert when it comes to this. This currently takes me days to complete, and I know it should not take this long. Please save my sanity!
View Replies!
View Related
Formula To Compare Columns If The Value Is Same
I have data in 2500 rows and 29 columns and need to compare cells in 5 columns if the value is same and make the font of cells that are same color red or make a different cell red if any value is not same. I did this with a macro but it takes few minutes(3-4). Now I try to do it with a formula but no idea how. Formula is faster.
View Replies!
View Related
Compare Values In Two Of The Columns
I have a worksheet where I want to compare values in two of the columns. In column B there are EAN codes consisting of 13 digits. In column E there are 5-digit numbers. What I want to do is to compare the 5 digit number with the EAN code where these digits should be in position 7-12 in the EAN code. Those numbers in column E that doesn't have a match in column B should be marked (for example that the background color of that cell is set to "red"). Example: B E XXXXXX12345X 12345 (match - do nothing) XXXXXX12346X 12346 (match - do nothing) XXXXXX12348X 12347 (no match - set background color to red) XXXXXX12349X 12348 (match - do nothing) XXXXXX12350X 12349 (match - do nothing) XXXXXX12351X 12352 (no match - set background color to red) There are more values in column E than B. In all there are close to 4500 rows so I really could use a nifty macro to do this job.
View Replies!
View Related
Compare Data Between 4 Columns
i want to compare data between 4 columns, 2 columns of data is in Sheet 1 and 2 columns of data is in sheet2. Data starts at A5 in both worksheets. Data consists of stock codes and there holdings. Sheet 1 data is real data the primary source, sheet 2 data is a bit of real data and incorrect data. My data in sheet 1 is layed out as below, this is just a sample, real data has around 1500 stock codes and holdings. Starting at A5 Col A (Stock) Col B (Holdings) 5 aap 10500 6 aax 10987 7 aas 76544 Sheet 2 data is layed out as above but holdings may differ, so Col A(Stock) Col B (Holdings) 5 aap 10500 6 aax 10300 7 aas 76534 I need a formula which will tell me which stocks holdings have changed in sheet 2 compared to sheet1.
View Replies!
View Related
Compare The Data Between The Two Columns
I'm working with Excel 2007, I have two tabs on my spreadsheet, each tab contains a column of numbers formatted like 5552220. Is there a way to run a macro or write a formula that would compare the data between the two columns and either automatically delete the numbers that don't have a match or highlight them? For example: Tab A Tab B 5551112 5551112 6660001 6660001 1234567 1234567 2222222 2222222 6666445 6666445 needs to be deleted in tab B because it's not present in tab A. There could be up to 100 numbers that require deletion from tab B.
View Replies!
View Related
Compare Sheet And Columns
[data] ... I have three sheet. named Sheet1, Sheet2 and Sheet3. Sheet1 being the master sheet. What I want to achieve is: I want to search for Name in sheet1 with the list of names in Sheet2, If the name is found, then compare the Age in Sheet1 and Sheet2. If the age matches make an entry in Sheet3 "matched" else "didnt match". If the name itself is not found on sheet2 , make an entry saying not found. I am not sure what would be the best approach to solve the problem(formula/VB)...
View Replies!
View Related
Compare Columns Between Two Sheets
The code below compares values on sheet 4 column A to sheet 3 column A and then colors a cell "Green" (Temporary), later I will place data from sheet 4 into sheet 3. I dont know why but when it finds data on sheet 4 that is not 100% numeric it errors out. Run-time error '91' Object variable or With block variable not set. The data in sheet 4 column A is primarily numeric, there are and always will be some numeric/alpha strings. I can change the value of sheet 4 A2 to "123x" from "123" and the code stops as described. Leaving sheet 4 A1 as 100% numeric, which works fine.
View Replies!
View Related
Compare Columns Of Data
I have column A with 228 rows and column D with 314 rows. Both columns have the same data except that D has different data. I would like to line up everything that is the same in A and D and everything else in column D that is not the same move to G. Is there a quick way to do this?
View Replies!
View Related
Compare Across Multiple Columns
I can find lots of ways to compare two lists with single columns, but I need a very basic guide to comparing multiple ones across two sets of data and then highlighting or extracting the unique records. I would prefer to keep the data in the existing columns for later sorting and other purposes. I currently have the two datasets as two separate worksheets in an Excel 2003 file. The two datasets consist of the same three columns containing strings of text, but there is quite a difference in the number of rows. Dataset One is c. 3550 records, Dataset 2 is c. 1600. There are no duplicate records within each dataset, but there are duplications across the datasets and the records are in a different order, so it's not a matter of comparing Row 1 to Row 1 and so on. The data look a bit like this (semi-colons to show columns): DATASET 1 Group;Family;Name PM;Smith;Mary Anne PM;Jones;Fred Henry PD;Wilson;Peter John PG;Green;William Laurence ...............
View Replies!
View Related
Compare Two Columns And Return Value
I have two columns with the same data type (text) and I want to compare one column to another and if they match, return the data from another column. For example: I have 2 columns of names on separate Excel files. One file contains name and phone numbers, while the other doesn't. I want to compare the names from file one with file two and if the names match, return the corresponding phone number in a new column. I've tried VLOOKUP and IF statements, but I can't get it to come out.
View Replies!
View Related
Compare Data In Columns
I have 2 columns say A and B (infinite number of rows) A is an Indexed number starting at 1 B is numerical data. I now have a second set of the same columns with the same data, however some rows are missing. I need a way of comparing the data and then display the rows I am missing in the second set of columns. For example the first set will be the master list and look like: Index Data 1 34 2 46 3 54 4 276 5 311 6 89 Second list has row 2 and row 5 missing. Index Data 1 34 3 54 4 276 6 89 The desired result is to have the missing rows displayed; Index Data 2 46 5 311
View Replies!
View Related
Compare Columns From 2 Sheets
I'm trying to cmpare two excel spreadsheets, each one of then have 3 columns with column A being the KEY to lookup and compare records into another spreadsheet. So in my example spreadsheet If u take cell ZVNA!A1 and lookup for values in ZSKU!A* and find a match then comapre the B1 and C1 in respective ZSKU! Column B and C. If there is a record for A1 in ZVNA then comapre it's column B value with column B value of ZSKU, and column C value with column C value of ZSKU. I have not used macro/vba before so if you could tell me formula based solution that will be good or point me how to use macro. I did Vlookup but it did not return me 100% accurate result may be bec my format of column is not accurate.
View Replies!
View Related
Compare Multiple Columns To Each Other
I would like to create an excel formula that will easily compare multiple columns to each other. For example C1 C2 C3 C4 -- -- -- -- A A B A I want to create a formula which will compare these 4 columns to make sure they are all the same. If they are all the same, then TRUE else FALSE. I could compare C1 to C2,C3&C4, then C2 to C3&C4, then C3 to C4 but I am thinking there must be an easier way to do this.
View Replies!
View Related
Compare Columns Between Worksheets
I have two worksheets, PM1DATA and AMDATA, i'm looking for a way to compare the two sheets and have any data that appears in collumn B within the AMDATA sheet, but NOT within collumn B of the PM1DATA sheet to be copied and moved to a sheet called NEWKITS. I would like the entire row to be copied when new data is found, not just collumn B.
View Replies!
View Related
Search Word For Text And Send Values Next To Text To Excel File
I am using Windows XP and Office 2003. I am looking to automate a process where information is sent to someone in a text format and they in turn transfer that data to an excel file. It basically looks like this (but includes a lot more info): Service Request #: 123456 Instrument Type: New Instrument Lot/Serial #: 123456 SR Type: Product Complaint Service Coverage: Maintenance Agreement The info on the left (text preceding the colon) is always the same but the values following the colon can change. The excel file has all of the text before the colon and they just enter the information into the cells. I am looking to make it so that an Excel macro (or maybe a word/outlook macro) automatically scans the text document and sends this info to the exact same cells in excel every time. The text file is actually a message from an Oracle database and I am not going to be able to make any changes to the way the data comes in.
View Replies!
View Related
Text Search Returns Cell Text Contents Of Different Column In The Same Row
Search a worksheet for a user defined text string, and have excell return the contents of a predetermined column in the same row in which the text string was found. A prepopulated worksheet has the text "gold" entered in cell T278. 1. user searches for "yellow_metal" 2. Excell finds "yellow_metal" in row 278, say in cell A278. 3. Excell then goes to predetermined column (programed as part of macro or VB), say "T", and returns the text contents of the cell in that column, T278 in this example. 4. Excell returns "gold"
View Replies!
View Related
Compare 2 Columns & Return In Third
I have a sheet with 2 big columns (3000 each). I want to search each element from the first column in the second column and put a message "Yes" if it is and "No" if it isn't, at the same position in the third column. How can i do that? I want to use the sheet for more than 3000 lines (about 5000). I attached an example.
View Replies!
View Related
Compare 2 Different Columns-show Difference
I'm looking at trying to view 1 large keyword phrase list of about 40,000 phrases to another large list. All I want is a macro, I can assign a button to. Click it and in a new sheet it shows only the rows of data that are different. I have tried googling it. I found 1 that looked very good (Not that I really know anything about coding, but I couldnt get it to work. I'm using excel 2007. As a note the link was here. [url] I might as well post the code,, but I just couldn't get it to work, shame, because it sounds like it could be what I was after, I'll post it now, but if anyone can help me with this that would be great Sub CompareWorksheetRanges(rng1 As Range, rng2 As Range) Dim r As Long, c As Integer Dim lr1 As Long, lr2 As Long, lc1 As Integer, lc2 As Integer Dim maxR As Long, maxC As Integer, cf1 As String, cf2 As String Dim rptWB As Workbook, DiffCount As Long If rng1 Is Nothing Or rng2 Is Nothing Then Exit Sub If rng1.Areas.Count > 1 Or rng2.Areas.Count > 1 Then MsgBox "Can't compare multiple selections!", _ vbExclamation, "Compare Worksheet Ranges" Exit Sub
View Replies!
View Related
Compare 2 Columns Then Give Count
I need a formula to look in column B and find all "jun" (or anything else that I put in there) THEN look in column J and find only all "d" (d is one of 3 choices there) that correspond to the "jun" then give me the count of the "d". This is an example. With the formula I can do a variety of things to get info that I'd like to have.
View Replies!
View Related
Compare Columns And Move To Different Worksheet
how to write the following in a macro. The task is to have the macro compare both the SSN, amount, and date...if they match go to next row. If Mysoft side exists without a match on the OMNI side, then range for that A-D will be cut and moved to Mysoft Only worksheet and the cells below will be moved up....same holds true for the OMNI side.
View Replies!
View Related
Compare And Count Recurrances, Two Columns
I'm working with a large amount of data comparing the proximity of bank branches. I want to find out how many branches two banks have within the same zip code. I have two columns, , A and B each with a list of 3000+zip codes. What I want to do is count how many of the cells in Column A are Equal to Column B. For example if I have the following two columns: 1 1 1 1 1 0 3 3 4 3 5 7 6 8 I would want to return the number 3 because Column A is equal to Column B 3 times(two times with 1, and 1 time with 3).
View Replies!
View Related
Compare 2 Columns From Diff Worksheets..
I'd like to compare 2 columns from different worksheets in the same workbook with a twist. If any and all data from worksheet 2-column c matches any and all data from worksheet 1-column c, then go back to worksheet 2-column B on the same data matching row, copy the data from that cell and paste it into the same row of the data match in worksheet 1-column b and paste it.
View Replies!
View Related
Compare Columns; Remove Matches
I've been searching for a method to compare two large columns of numbers and remove replicates from the "main" column. Column A has all the numbers that are in column B and many more. I want to remove all the numbers from column A that are in column B. The result being two columns with no matching numbers. (or a third column that has only the numbers from 'A' that are not in 'B'). My search results on this forum have found results that compare rows for matches & can make deletions; and also one method that could mark all the entries that were duplicates in both columns, but nothing to remove them. The datasets I am using have over 400k entries in some columns, so manual removal of marked ones is not feasible. I need an automatic deletion method.
View Replies!
View Related
Compare 2 Columns And Remove Dups
I have 2 columns of data (1 of 7000 and 1 of 39000). First column of 7000 entries should all be in the second column. Example: Record OLDRecord NEW DBE2008/49IEP2007/0032 DBE2008/48IEP2007/0033 DBE2008/47DBE2008/47 DBE2008/46DBE2008/44 DBE2008/45RIE2008/0212 DBE2008/44TK2004/0073 DBE2008/43ID92/0522 DBE2008/42ID96/0274 IEP2007/0032DBE2008/41 I would like to compare these 2 columns and remove the 7000 entries from the second column. This can either be removed from the second column or resulted in another column. I am only quite new to Excel and formulas
View Replies!
View Related
Compare 2 Columns On 2 Worksheets For Matches
I know there is a forumla to compare a small database to a list, but can't find it (I used to use French Excel). Here is an example : In a sheet, my small database : (in two different cells) Value1 and ValueA Value2 and ValueB Value3 and ValueC etc... In another sheet, my list : I have a list where there's a lot of Value1, Value2... in one column, and in the next column, a lot of ValueA, ValueB.... I want to check in my list : if I have Value1, then, on the same row (next column) I have ValueA, if I have Value2, then, I should have in the same row (next column) ValueB.... And if I have Value1 and in the same row (next colum) ValueB, I want some kind of "Error" text. Can't find this function nor (of course) the criteria to use it correctly.
View Replies!
View Related
Match And Compare Columns On 2 Sheets
I have a list of names on 2 separate sheets that I need to modify. If I have a name on sheet1 matches a name on sheet2 I would Like to add a "space" then "(SV1) at the end of the text string on sheet2. I have a list of 1500 and will only have to modify 75-100. Example shows on sheet2 how I would like the desired outcome to be.
View Replies!
View Related
Compare 2 Columns And Return Matches
I have two columns, one with the target text (D:D) and one with text I want to compare it too (A:A). If the text in column (D:D) matches the one in (A:A), I want to return the value in (B:B). I attached a sample of the problem i'm dealing with.
View Replies!
View Related
Compare 2 Columns For Close Matches
I want to compare two columns (from two different files, but copied into a new sheet) for duplicates or identical entries. But here's the trick, each entry contains atleast a number of digits. I'm not quite sure how to find items that may be 80% identical (in the right order, but might be messing a digit, or there is a dash or a 'o' instead of a '0'). I know how to do it in C++ or Java, but not quite sure how to do it in VBA/macro. Here's an example of what I meant. Let's say column one has the following: 0244-34 9393-O0 3932-44 and second column has 939300 493384 938923 If I was comparing second column to first column, it can pick up the 9393-O0 one because it's close enough to 939300.
View Replies!
View Related
Find, Compare And Delete From 2 Columns
I an using Excel 2003. In that i am having 2 columns (A&B). I need to take each value from Column A and search that cell value in Column B. If it is not found in Column B then delete the cell data in Column A. Then take the next cell data in Column A. Find operation and delete if not found. Do it for entire rows in column A. Then repeat that for Column B also. So my final result will be the same cell value in Column A and B. I need VBA code.
View Replies!
View Related
Compare Columns For Name Collected From User
The attached file contains a list of customers from 2 years in column A and B respectively. I want to write a sub that takes a single argument customerName(a string variable) and it checks whether the customer is in both lists. If so, I want it to display a message and bolds both instances of the customer's name. Otherwise, I want it to display a message that the customer's name is not on both lists. I also want to write a sub that uses an input box to ask for a customer name, then calls the original sub with the customer's name as the argument.
View Replies!
View Related
|
TRACKER
