Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text match?
Hello all,
I'm using the following to copy weekly sales quote info to a running master list: Sub quotestomaster() Set Rng1 = Workbooks("JeffQuotes_weekly.xls"). _ Sheets("Sheet1").Range("B3:R22") Set Rng2 = Workbooks("JeffActiveQuotes.xls"). _ Sheets("Sheet1").Range("A" & Rows.Count).End (xlUp).Offset(1, 0) Rng1.Copy Rng2 End Sub Since each job name is unique (appears in column B of weekly file, column A in master) I want to ensure that no duplications occur on the master. So, I need to see if a match exists and if so, either don't copy it in the first place or delete the match after copying. Wondering if I can do something (in theory) in the master like... =IF(TEXT(A1,"abcdefghijklmnopqrstuvwxyz") ="abcdefghijklmnopqrstuvwxyz" Then EntireRow.Delete Thanks in advance for response! Erin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match text | Excel Worksheet Functions | |||
Match a text | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
How to match two different cells text, if the text is not in the . | Excel Worksheet Functions | |||
match cell text with text in formula | Excel Worksheet Functions |