Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Check Duplicate, Missing Number


Hi guys/gurls.. is there a way i can get the following check against range for orders which give result as invoiced(if within the range), duplicated(if 2 or more than 2 are on the orders list) & missing (which on not in the orders when checked against the range).


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Check A Userform For Missing Data
I have created a user form for some data submission. I am looking for a macro to check the text boxes, that I have named appropriately i.e. Name, Address, City, State etc. , to make sure there is something entered.

If nothing is entered it needs to return a msgbox that says what field is blank.

View Replies!   View Related
Check For Missing Entries Before Saving
How can I make this code repeat itself on different lines?

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Sheets("Sheet1"). Range("A10").Value > "" And Sheets("Sheet1").Range("B10").Value = "" Then
MsgBox "Please Enter Order Number in Line 10"
Cancel = True 'cancels the save event

End If

End Sub

The code works perfectly for that one line but I need it to repeat independantly in the same columns but for rows 11 up to and including 23.

If I need to make the message generic like " Please Enter Order Number" then that's fine.

View Replies!   View Related
Check Date & Time For Missing Hours
I have a column A with some dates at this format "dd-mm-yyyy hh-mm".
In this list, some hours are missing, and I don't know which ones.

In order to find the missing hours, I created an additional column B, displaying all the hours, this way:
B1=01-01-2006 00:00:00
o
B1=A1

And then : B2=B1+"01:00:00"

Then, in column C, I compare both columns A and B:
C1=IF(Value(B1)=Value(B2),ok,missing)

As a result, I first get some "ok", and then more and more "missing" statements, even though the dates look the same.

I checked the numerical values of my dates. At the first "missing" statement, I saw that there is a slight difference in the numerical values, at small decimals...

Can you tell me how to define my date /time in a good way, in order to avoid this kind of problems, please?
(I could take the int part of the numbers, but this could lead to further errors, so I prefer to define my dates in the right way, from the beginning).

View Replies!   View Related
Duplicate Check On Export Of Records
I have a spreadsheet that will export records when I "click" a button, to a spreadsheet on a network drive.

I would like to attach some code that will check to see if a duplicate record is going to be written to the network drive, and if so, alert the user that they are about to create a duplicate . If it is a duplicate, give the user the option to overwrite the existing record.

Ex. I export the results for account 12345.....Account 12345 is now written to an outside sheet.

User2 logs in and works with customer 12345, w/out knowing that someone has already worked with this account, presses the export button.....This is the trigger point for what I want to happen. At this point when it locates a dupe in the outside spreadsheet it will prompt the user too make some chouces .

find attached the code I would like to attach this to...

HTML option Explicit

Sub TransferData(Optional Dummy As Long)

Dim Row As Long
Dim TargetRow As Long
Dim Path As String
Dim Prompt As String
Dim Title As String
Dim Cel As Range
Dim Wkb As Workbook

Application.DisplayAlerts = False
Application.EnableEvents = False
Application.ScreenUpdating = False

Set Cel = wsCustomers.Range("C:C").Find(What:=Range("C4").Value, LookIn:=xlValues, LookAt:=xlWhole, MatchCase:=True)
If Cel Is Nothing Then
Prompt = "There is no match for the Customer Number (" & Range("C4").Value & ")."
Title = "Process Aborted"
MsgBox Prompt, vbCritical, Title
GoTo ExitSub:
End If
Row = Cel.Row

Set Cel = wsSetup.Range("A:A").Find(What:=wsCustomers.Range("A" & Row).Value, LookIn:=xlValues, LookAt:=xlWhole, MatchCase:=True)
If Cel Is Nothing Then
Prompt = "There is no Workbook Path setup for this Region (" & wsCustomers.Range("A" & Row).Value & ")."
Title = "Process Aborted"
MsgBox Prompt, vbCritical, Title
GoTo ExitSub:
End If
Path = wsSetup.Range("B" & Cel.Row).Value

If Trim(Path) = "" Then
Prompt = "There is no Workbook Path setup for this Customer Number (" & Range("C4").Value & ")."
Title = "Process Aborted"
MsgBox Prompt, vbCritical, Title
GoTo ExitSub:
End If

On Error Resume Next
Set Wkb = Workbooks.Open(Filename:=Path, UpdateLinks:=False)
On Error GoTo 0
If Wkb Is Nothing Then
Prompt = "The workbook for this Customer Number (" & Range("C4").Value & ") could not be opened." & vbNewLine & vbNewLine & "Path: " & Path
Title = "Process Aborted"
MsgBox Prompt, vbCritical, Title
GoTo ExitSub:
End If

View Replies!   View Related
Check The Duplicate Name In The Sheet Using VB Macros
I want to Check the Duplicate Name in the Excel Sheet Using VB Macros
****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11">

If the 1 nd Row Contains Name as " 101 Calif " and the Value For Vb is 77
2 nd Row Contains the Same Name "101 Calif " and the Value for this is 2.

Now I want the Output As Follows

101 Calif and Column 3 values is 79(77+2) and Column 5 Value is 105 and Column 7 Value is 105 and Column 9 is 100 and Column 11 is 3 and Column 13 th Value is % Value . (10+30/2 = 40/2= 20 )

***** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"> Vendor
Actual YTD Annualized
Forecast
2007 Actual Difference % Change.........................................


View Replies!   View Related
Check For Sheets With Duplicate Names
I have written some code which asks the using for a name, selcet's a sheet, copy's the sheet, rename's the copied sheet then hide's the original sheet and makes the copied sheet with new name active.

My problem is that I need some sort of code to check for sheets with duplicate names and if true ask the user to rename the sheet or maybe delete the sheet.

View Replies!   View Related
Copy Sheet - Check For Duplicate Name
I have a command button that copies a template worksheet and names it with a date that the user chooses. Problem is, the user can choose the same date more than once. So, I need to have the command button check for all the sheet names, and if it finds a duplicate, prompt the user to enter some text to concatenate to the original sheet name, therefore making it's name unique. My existing code is as follows:

Private Sub CommandButton1_Click()

MsgBox "Please be patient. Creating a new Week Ending sheet can take several minutes!"

Call AddNewWE

End Sub

Sub AddNewWE()..............................

View Replies!   View Related
Automatically Check Each Worksheet For Duplicate Entry
I have multiple worksheets of computer equipment, each worksheet is a group/department. Column H is the serial number column and the entries have to be unique. I have managed to create the code below which does find duplicates across worksheets.

When error message pops up about which sheet the duplicate already exists on, the duplicate entry is deleted and the cell is blank but the error checks again and reports the blank existing on another worksheet and then it is stuck in a loop. How can I ignore the blank or null.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim I As Integer
I = Sheets.Count
If Not Intersect(Target, Range("H2:H200")) Is Nothing Then
Do Until I = 0
If Application.IsError(Application.Match(Target, Sheets(I).Range("H2:H200"), 0)) Then
Else
MsgBox "That entry already exists in the " + Sheets(I).Name + " sheet"
Target.ClearContents
End If
I = I - 1
Loop
End If
End Sub

View Replies!   View Related
Find Missing Number From Chart.
i have two chart A and chart B from ,chart A got nine repeting numbers and Chart B will show what is the number not in chart A or is outside from this number 0.1.2.3.4.5.6.7.8.9. i want auto generate to chart B.

View Replies!   View Related
Enter Missing Number On Specific Place
I have some 9digit numbers and i have to enter the number 9 afther the fourth digit. Example : 50200491 - turned into 502900491.

View Replies!   View Related
Return Missing Number In Linear Numeric Series
I need to create a formula (not a VBA code as it is a shared spreadsheet) to bring up the next number in a sequence. For example

1
2
4
5

The outcome would be 3 as it is the first number that has not been used.

View Replies!   View Related
Read The Number And Check For The First Number With The 2nd Number
I have this set of number..

987654.

What im trying to do is this..I read this number and check for the first number with the 2nd number. If its greater then i will swap it. Im trying to do this so that my number can be rearranged as 456789.

View Replies!   View Related
Compare Two Columns, If Missing Insert Missing Data
I have two columns which i want to compare, they contain text data such as A123.

what I'd like is if its in column A and not in Column B then add to bottom of column A.

Once its in column A i can do the vlookup's to draw the other data, costs etc, over but don't know how to identify, and add, the missing codes to the list.

View Replies!   View Related
Alert Me Upon Entering Duplicate Number
Is there a way to have Excel alert me (via cell color change preferably, but another method would be fine also) upon entering a number that has already been entered on that worksheet?

The problem I have:

I have 10 columns in a worksheet that I keep track of serial numbers in for work... Sometimes someone enters the wrong serial number or doesn't update a serial number so we will have the same serial number in two different places and another agency will call us to correct our mistake, making us look inept.

I figure the best way to alert people of this input error would be to change the fill color of both, or the active, cell(s) so they could immediately begin looking into the problem.

View Replies!   View Related
Keep ONLY Duplicate Matter Number Rows
Is there a way to delete any rows that don't have a second occurrence of any cell in column a? I have unique numbers ONLY in column A. I want to tell Excel to.

a) Look at all the cells in column A ONLY (about 6,000 of them).
b) Look for any cells column a that have a duplicate entry in another cell.
c) Delete all rows that don't have a duplicate cell in column a.

This would be the entire row that I would like deleted. So every row should now only have the header info followed by 2 identical cells in column A. NOTE THAT THE OTHER COLUMNS WILL HAVE DIFFERENT INFO IN THEM, WHICH I WANT TO KEEP. I ONLY WANT THE CELL IN COLUMN A TO MATCH.....

View Replies!   View Related
Adding Data With Userform: Check For Duplicate Before Adding
I have a userform that I'm using to add data to a worksheet, with the following

Private Sub CommandButton1_Click()
Dim OutSH As Worksheet
Set OutSH = Sheets("Sheet1")

OutSH.Cells(nextrow2, 1).Value = Surname.Value
OutSH.cells(nextrow2,2).value = ID.value
OutSH.cells(nextrow2,3).value = Date.value
......
I need to ensure that duplicate entries are not made for the same person on the same date. The ID is unique to each person.

IF statement that can check for a duplicate and then come up with a dialouge box with some custom text, and then exiting the sub?

View Replies!   View Related
Sequentially Number 1 Occurence Of Each Duplicate In Column
how many accounts, and list the total on the bottom.
So, I have something like this:

10003722
10003722
10003722
10003722
10008981
10008981
10008981
10008981
10008981
10028163
10034527

I need the column next to it to show #1 next to 10003722 than jump to the next one and have 2 next to 10008981 and so on...

View Replies!   View Related
Duplicate Rows Based On Number In Text
I have a problem of having to repeatedly copy and paste a series of data based on the number of occurrences in each row of data series. For instance:

[Road Name] [Building Name] [No. of occurrence]
(1) [Scotts Rd] [Tangs Building] [38]
(2) [Orchard Rd] [ABC Building] [3]
(3) [French Rd] [DB Bank] [1]

I will need to duplicate (1) 38 times with the location name and building name. Similarly, I need to duplicate (2) 3 times. How can I simplify it programmatically?

View Replies!   View Related
Return Row Number Of LAST Numeric Consecutive Duplicate In Column
Using a Dynamic Named Range "Data", I would like a Formula to return the Row
Number of the "LAST" instance of a duplicate numeric value - repeating twice
consecutively in the same column.

View Replies!   View Related
Finding Duplicates (cell At The Top Show Row Number Of Duplicate)?
i have duplicate cell entries occuring. I have a column of about 8000 entries (Column B) and would like to have a cell at the top of my spreadsheet that displays where the first duplicate resides (Row No. will suffice).

At present i have a conditional format on dupllicates, but is is a big task to scroll down through all the data looking for them.

View Replies!   View Related
If And Formula- To Check One Number Against Another
=IF(OR(Q136<O132,Q136>O132),Q136-O132,O132-Q136)

This does not seem to be working for me. I need to check one number against another and if the one cell is larger then the other subtract it or just the reverse.

View Replies!   View Related
Check To See If A Number Is Between Two Numbers
I have a list of numbers that I have to concatenate with another number depending on if it falls within the parameters and I don't know how to do a lookup on that. I currently am using a complex if/or/and statement which is too dificult to debug and extremely complex like this: if(OR(AND(a>=1,a<=10),AND(a>=20,a<=30)),concatenate(a,"123"),if(OR(AND(a>10,a<20),(a>30,a<40))),conc atenate(a,"456"),"a is not in the parameter")

is there a way to do a lookup for this?

Something else to throw into the mix, there are some ranges that shouldn't be there and return nothing so from 40-55, there shouldn't be a result.

also, there are some that are just one number (56 gets 789 but then at 57 it goes back to abc)

View Replies!   View Related
Check If String Contains A Number
Is there way in Excel VBA to check if a string contains a number, and then return TRUE or FALSE. Numbers can been anywhere in the string. See example below.

View Replies!   View Related
Check If Number Is Between Other Numbers
I'm looking for a formula to check whether a given number is between two other numbers.

Example: I have a list of data items which give the following info:

A.......B..........C.........D
ID# Group Low# High#
1001 food 12345 13960
1003 soap 27192 32245
2004 tires 93471 95532
2005 food 71174 76772
2006 soap 33183 36591

Such a list is many hundred of lines long.

Then I have other data which provides a Group ID and a product number, which number is likely to between the Low# and High# in the data list.

What I want is a formula to check whether the product number is between the Low# and the High#, AND that the Group matches.

Example: the data being supplied is Soap 28332. So, I want a formula to check through the data list, and if 28332 is between the Low# and the High# AND if the group SOAP matches, then give back the correct ID number.

Thus for the data Soap 28332, I would want the answer to be 1003, which is the ID # for soap in the given range.

A data listing of Food 73776 should give back the ID 2005, etc, etc. This list of data needing the correct ID# is thousands of lines long.

Thus I need a formula to check that the given number is within the low and high #, and that the group designation matches. If so, then give back the correct ID#.

View Replies!   View Related
Check Initial Number
i need code to check if number is "Initial Number" (3, 7 etc.)

View Replies!   View Related
Check Cell Value Is A Number?
I'm writing a function that sums the values in a range of cells but some are errors due to my formula's. any way i can check if a value is a number in VBA?

View Replies!   View Related
How Can I Check A 4 Column Range For A Particular Number
I would like to check a 4 column range to see if a particular number has been added to a range of number.

this is the formula that I wrote but it does not test beyond the 2nd column.

=IF(OR((MATCH(3,COLUMN_D)),(MATCH(3,column_c)),(MATCH(3,column_b)),(MATCH(3,Column_a))),3,"")

Does anyone have an different way of check for this?

View Replies!   View Related
VBA: Check If The Value Of A Cell Is A Number
1) check if in cell A1 there is a number. Something like

If .Cells(1,1).Value is number then ....
2) how to get the "code" of cell A1 in VBA (i.e =code(A1)).I tried
.Cell(1,1).Code
but it didn't work.


View Replies!   View Related
Check If Any Number In A Column, Appear More Then 3 Times...
I have this list with articles at work. It looks like this:

1
1
1
2
2
2
3
3
3
etc

I wish to find out if any number in a column appear more then 3 times, and if it does, return that number to be. Is this possible with a formula? I've tried, but didn't succeed.

View Replies!   View Related
Check If The Number Have Two Decimal Point
a1 -> 2.333.33 "i want this to return as 2,333.33"

a2 -> 33.33 "i want this to retun 33.33"

a3 -> 45.555.55 "i want this to return 45,555.55"

i already asked this question and someone gave me this code -> substitute(a1,".","",1) which return to 2333.33 but the problem is for the a2 if i use the code it will return as "3333" which read as "3,333".

Is there any way that we can determine if the values have two decimal point before it will run the command?

View Replies!   View Related
Check If Character Is A Letter Or A Number
I have a cell range that is passed as a String to a function, and within that function I need to extract only the Column letter. If it was just 1 letter it would be simple, but it may be 2, so does anybody know of a way of testing to see if the second character is a letter or a number?

View Replies!   View Related
Number Format And Duplicates Check
I am trying to improve my expense report template and need to check on the load if expense report number has been loaded correctly as well as if this report has been previously loaded. Expense report number format looks like this: AAA-BBBBBB-CC
Where:

AAA Employee ID #
BBBBBB End of the week date

CC Weekly expense report number
For instance, 023-122008-01 means: Employee number 023, week ending date 12/20/2008, weekly expense report number 01. I would like to prevent/give warning of loading incorrect expense report number format, check for possible duplicates, and check if trying to load expense report belongs to the right person (by simply matching previously loaded in different cell of the same sheet employee ID and first three digits of just loaded expense report number. I think I know how to do all of these separate, but have no idea how to combine all three checks for one cell.

View Replies!   View Related
Check Number Uses Unique Digits
I would like a function that checks an input number to see if it contains unique digits. If the digits are unique the output is 1 else the output is -1. Thus, supposing we call the function UNIQ(), we find UNIQ(15423) = 1 but UNIQ(154532) = -1. The input is always a positive integer.

View Replies!   View Related
Vba Macro: Check A Large Number Of Cells
What i'm trying to do is to check a large number of cells, if "0" is written down in that cell it stays as it is and if the number is different from "0" i want to put a "1" instead.

View Replies!   View Related
When Typing To A Cell Check If This Number Exist In A Range Of Cells (in Sheet 2)
I need help to this : When i type a number to a cell and press enter , i want to check if this number exist in a range of cells (in sheet 2) , and if exists , excel show me a message. Actually i use it for my *** club. Number is the client code. When i writte 50 in a cell , i need from excel to check if this client own me money , and show me some message..

View Replies!   View Related
Mark Duplicate Values :: Insert Word Duplicate Next To Row
I am using the following macro to insert the word "Duplicate" in the first blank column next to a duplicate row. My data is sorted by the first column. Data Example:

12345 a
12345 a DUPLICATE
11111 b
23123 b

Here is the macro I am using and it does not work. It marks the first duplicate it finds then goes into an infinite loop. Any Idea where I went wrong?

Sub MarkDupes()
x = ActiveCell.Row
y = x + 1
Do While Cells(x, 1).Value <> ""
Do While Cells(y, 1).Value <> ""
If (Cells(x, 1).Value = Cells(y, 1).Value) Then
Cells(y, 3).Formula = "Duplicate"
Else
y = y + 1
End If
Loop
x = x + 1
y = x + 1
Loop
End Sub

View Replies!   View Related
Sum Duplicate Values Then Delete Duplicate Rows
I have 4 columns in my spreadsheet. I am trying to find any duplicates that may exist in Col A, sum values in Col D, then delete the entire row. So far my sheet before I run my vba code is this.

Col A
100
101
102
105
100
101
102
105

Col D
5
4
2
4
1
2
3
1


After my code is run, I need for my spreadsheet to look like this
Col A
100.........................


View Replies!   View Related
Delete Duplicate Rows :: Duplicate Company Names
I have a spreadsheet with 3300 rows. In column A there is a list of company names and in column H there is a corresponding Sales Rep name.Column A has many duplicate company names. I would like to run a macro that will find the a company name and then delete all the rest of the rows that contain that same company name.

Attached is a sample of that spreadsheet.

View Replies!   View Related
Delete Duplicate Cells Or Rows With A Duplicate Cell
I feel as though I have spent enough time searching the previous posts to ask this question.

I have a 4 column sheet, column B has many cells with identical data. I want to delete all the rows that that have duplicate data in column B.

COLUMN A= Car Makers
COLUMN B= Models of cars
COLUMN C= color
COLUMN D= owner

I want to end up with rows that each contain unique info in COLUMN B.

View Replies!   View Related
Cross Check 2 Ranges For Matches & Return Row Number Of Matches
I have several worksheets (Labeled Sheet1,Sheet2,sheet3) What I need to do is to step through each row in sheet3, and do a search in sheet1, it the data was found, then return the row number. I then will need to copy data from sheet1 (rowfound columnA , through rowfound CoulmnBd to sheet3 current working row columnK

View Replies!   View Related
Macro To Force Format And Check Barcode Check Digit
My company uses 4 types of barcodes 8, 12, 13, & 14 number barcodes for our products my problem is that I can't figure out how to force the barcode to format properly no matter how somebody enters it if they don't use spaces or put them in the wrong spots, I can't use custom formats because there is 4 different layouts

8 digit should be "#### ####"
12 digit should be "###### ######"
13 digit should be "# ###### ######"
14 digit should be "# ## ##### ######"

these barcodes are in columns L, M, & N also right now 'm using a formula in another cell to verify the barcodes by calculating the check digit and comparing it to the check digit typed the formula i'm using is

View Replies!   View Related
Check All Check Boxes With CheckBox
I am creating a userform with 10 checkboxes. The first 9 checkboxes are user options. I want the 10th check box to be a "Select All" option i.e. if the 10th checkbox is checked all the other 9 options are deemed to have been selected.

The way I want the display to work is that if the 10th checkbox is ticked all other checkboxes are cleared. Also if the 10th checkbox is ticked and any of the other check boxes is selected then the 10th checkbox should be selected.

I have tried coding this up but the checkboxes don't seem to operate as desired. I placed some code on the click event for the last option button to set the vlaue for all other buttons to false. This works but the 10th check box doesn't get ticked itself. When I try to code up the other bit I get similar issues.


View Replies!   View Related
Missing From One Or Another Sheet
I have 2 spreadsheets. One has one type of info and another has another type of info for the same items.
For example:

1st spreadsheet has: server name, serial number, model.
2nd spreadsheet has: amount of memory for each server, number of CPUs, etc.

Note that some servers are missing from one or another sheet. So all info needs to be combined.

What is the easiest way to combine all info in a single spreadsheet?


View Replies!   View Related
Missing Tooltip?
I have attached a screen shot of vlookup formula. Whilst selecting a range a little tooltip comes up showing how many rows and columns have been selected (6R x 2C) ...

... at least that's what used to happen. Now this handy tool tip does not show on my PC - and I have no idea how I turned it off, or more importantly how I can turn it back on again.

I am running Excel 2002 SP3 on Windows XP.

View Replies!   View Related
Missing Library
Can anyone answer this one for me - why does this piece of code run on some machines but not on others - I suspect it is something to do with a missing library but I have no idea which one.

When the code fails it highlights the word " Date" inside the brackets


TrainingDateBox.Value = FormatDateTime(Date, vbLongDate)

Is there an alternative code?

View Replies!   View Related
Missing Rates
i have a bunch ofdaily rates back from 2005. sometimes ill have one or even 2 or 3 missing rates in a row. when there is a blank rate, i just want excel to calculate the average of the date below and the date after. right now, ive just been going manually to each missing date's rate and calculating the average.

View Replies!   View Related
Missing Borders
I have created a 4 page chart in landscape with text in each of the 4 columns in the chart.

When I looked at it in print preview the chart did not fill the page and so to widen the last 2 columns I dragged them over to the right hand margin. I am still definitely within the right hand dotted line showing the margin limit.

The problem is that I cannot now put a border line down the extreme right hand column. Every time I click on any of the border instructions in the Font tab nothin appears on the right hand side of the box.

View Replies!   View Related
Missing Values As Non-zero
I am facing a problem importing Excel data into a finicky graphics program. This program can't accept strings and numbers in the same column. Hence, strings such as #NA, or Excel's standard "" can't be used where there are missing values, as the entire column is then ignored.

But, I would like to provision for future data below the rows that currently exist.

Let's say I am trying to read data from Sheet1 of a workbook. The rows in Sheet1 contain formulas referencing other sheets (e.g. Sheet2!C1-Sheet2!C2). So, if Sheet2 doesn't have data in a certain row, Excel would show 0 in the formula on Sheet1. That would mess up my graph. If I use any other string or "" using a If statement for missing data, then the graphics program doesn't work.

Is there any way say, using dynamic ranges or similar, to populate blank cells in Sheet1 as data arrive in Sheet2, without a pre-existing formula being present in these Sheet1 cells? I can imagine that VBA macros will easily do this (e.g. the thread on Autofill below). But, is this possible without having to trigger a macro as and when additional data arrive?

View Replies!   View Related
Missing Link
I have a hyperlink in my excel file which refers to cell in a separate excel file (which no longer exists). I therefore would like to remove this 'dead' link as it keeps trying to update it when I open the file.

I don't remember where this hyperlink is in this huge multi-sheet file so I can remove it! How do I have excel show me all hyperlinks and the option to remove them?

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved