INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Need to populate two columns based on content of adjacent two columns.

Need to populate two columns based on content of adjacent two columns.

(OP)
Hi Forum,

I hope this isn't too much to ask. I am trying to find a formula or VBA for the following:

There are four columns 1000s+ deep - A, B, C and D.

C may or may not contain a value. D contains 0 or 1. The formula needs to enter data into A and B, depending on what is in C and D.

There are four possible scenarios and their responses are:


1: Nothing is entered in C and there is a '1' found in column D. - RESPONSE: Enter 'orange' in column A.
2: Nothing is entered in C and there are only zeros in column D. - RESPONSE: Enter 'plum' in column A.
3: Something is entered in C and there is a '1' found in column D. - RESPONSE: Enter 'apple' in column A.
4: Something is entered in C and there are only zeros in column D. - RESPONSE: Enter 'raisin' in column A, and 'cherry' in column B.


There are no blank rows between any section. Any one of the four possible scenarios may exist in any section.

Thanks in advance for any help.

http://files.engineering.com/getfile.aspx?folder=3...

http://files.engineering.com/getfile.aspx?folder=b...

RE: Need to populate two columns based on content of adjacent two columns.

Hi,

This would be a spreadsheet solution...

A2: =IF(ISBLANK($D3),IF(E3=1,"orange","plum"),IF($E3=1,"apple","rasin"))
B2: =IF(AND(NOT(ISBLANK($D3)),$E3=0),"cherry","")


This would be a VBA spreadsheet solution...

CODE

Function EdLow(Sector3 As Variant, iDecimal As Integer, Col As Range)
    If Sector3 = "" Then
        If iDecimal = 1 Then
            If Col.Column = 1 Then
                EdLow = "orange"
            Else
                EdLow = ""
            End If
        Else
            If Col.Column = 1 Then
                EdLow = "plum"
            Else
                EdLow = ""
            End If
        End If
    Else
        If iDecimal = 1 Then
            If Col.Column = 1 Then
                EdLow = "apple"
            Else
                EdLow = ""
            End If
        Else
            If Col.Column = 1 Then
                EdLow = "rasin"
            Else
                EdLow = "cherry"
            End If
        End If
    End If
End Function 
...where the function on the sheet would be...

A2: =EdLow($D3,$E3,A$2)

...and copy/paste to B2 then copy/paste down.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
Thank you Skip. It does not work though. Possibly I'm entering the formula wrong - I'm not sure. The first formula returns 'raisin', the second returns 'cherry' - no matter which cell I enter it into.


Creating a new macro with the VBA gives the error 'Complie error: Expected End Sub'.

I labeled it raisinmacro.

I probably made a mess of it:


Sub raisinmacro()
'
' raisinmacro Macro
' Macro recorded 11/7/2016 by K
'
Function EdLow(Sector3 As Variant, iDecimal As Integer, Col As Range)
If Sector3 = "" Then
If iDecimal = 1 Then
If Col.Column = 1 Then
EdLow = "orange"
Else
EdLow = ""
End If
Else
If Col.Column = 1 Then
EdLow = "plum"
Else
EdLow = ""
End If
End If
Else
If iDecimal = 1 Then
If Col.Column = 1 Then
EdLow = "apple"
Else
EdLow = ""
End If
Else
If Col.Column = 1 Then
EdLow = "rasin"
Else
EdLow = "cherry"
End If
End If
End If
End Function Application.Goto Reference:="raisinmacro"
Application.Run "Book10!raisinmacro"
Application.Run "Book10!raisinmacro"
Application.Run "Book10!raisinmacro"
Range("B1").Select
ActiveCell.FormulaR1C1 = "A2: =EdLow($D3,$E3,A$2)"
Range("B1").Select
Selection.AutoFill Destination:=Range("B1:B2")
Range("B1:B2").Select
Selection.ClearContents
Range("J34").Select



RE: Need to populate two columns based on content of adjacent two columns.

I am totally confused by your reply.

Here is my test table with the results using my formula...

SECTOR-1	SECTOR-2	SECTOR-3	DECIMAL
orange                  			1
plum                     			0
apple           		J510M240001	1
rasin   	cherry  	5UH46302E	0
 

I was actually perplexed by your test table. You table is not a typical table with one row of headings followed by data and nothing else. You have tables stacked on tables. What is the business case for such a structure? It is very unorthodox and does not lend itself to the data analysis features that Excel employs. The sections are VISIBLY separated, but your data structure cannot discriminate between one section and the next, unless you add a helper column to discriminate.

And the other thing that you did was to put your own EXCEL ROW and EXCEL COLUMN in the sheet, which I just realized, which throws everything off! Is that how you have your actual sheet structured; with column A having 1 in row 2 and row 1 having A in column B?

Please give me some confirmation of what your intent is for this sheet.

Give me a few minutes to work all this total confusion out.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

1) I DELETED row 1 and column A in your workbook

2) I added a column named Section with the following formula...

E2: =IF(D2="DECIMAL",1,0)+IF(ISNUMBER(E1),E1,0)


3) The formulas...

A2: =IF(ISBLANK($C2),
IF(ISNA(MATCH(1,OFFSET($D$1,MATCH($E2,Section,0),0,COUNTIF(Section,$E2),1),0)),"plum","orange"),
IF(ISNA(MATCH(1,OFFSET($D$1,MATCH($E2,Section,0),0,COUNTIF(Section,$E2),1),0)),"rasin","apple"))

B2: =IF(NOT(ISBLANK($C2)),
IF(ISNA(MATCH(1,OFFSET($D$1,MATCH($E2,Section,0),0,COUNTIF(Section,$E2),1),0)),"cherry",""),"")






Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

...and here's the VBA function, again with row 1 and column A deleted from your example workbook. This function needs no helper column.

CODE

Function EdLow(Sector3 As Variant, rDec As Range, Col As Range)
    Dim lRow As Long, bFound1 As Boolean
    
    Application.Volatile
    
    bFound1 = False
    lRow = rDec.Row
    
    Do While lRow <= ActiveSheet.UsedRange.Rows.Count
        Select Case Cells(lRow, rDec.Column).Value
            Case 1
                bFound1 = True
                Exit Do
            Case "DECIMAL"
                Exit Do
        End Select
        lRow = lRow + 1
    Loop

    If Sector3 = "" Then
        If bFound1 Then
            If Col.Column = 1 Then
                EdLow = "orange"
            Else
                EdLow = ""
            End If
        Else
            If Col.Column = 1 Then
                EdLow = "plum"
            Else
                EdLow = ""
            End If
        End If
    Else
        If bFound1 Then
            If Col.Column = 1 Then
                EdLow = "apple"
            Else
                EdLow = ""
            End If
        Else
            If Col.Column = 1 Then
                EdLow = "rasin"
            Else
                EdLow = "cherry"
            End If
        End If
    End If
End Function 

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
Thank you again for your time in responding to my post. Due to time considerations, I am having a programmer look at it. I greatly appreciate your help.

RE: Need to populate two columns based on content of adjacent two columns.

As far as I know, you cannot have a Function inside a Sub. Even though a module may iterate itself to completion (or get stuck in an infinite loop and crash). I have never seen it done as in the manner you have posted....

CODE

I labeled it raisinmacro.
I probably made a mess of it:


Sub raisinmacro()
'
' raisinmacro Macro
' Macro recorded 11/7/2016 by K
'
Function EdLow(Sector3 As Variant, iDecimal As Integer, Col As Range)
If Sector3 = "" Then
If iDecimal = 1 Then
(...)
End If
End Function Application.Goto Reference:="raisinmacro"
Application.Run "Book10!raisinmacro" 

Please note a Function can be called from a Submodular programming section; but not from inside itself. (I don't know if you'll understand what I'm saying but I can only hope you can to some degree.)

You should paste the Function EdLow coding in the GENERAL section (aka: all by itself) and NOT INSIDE your Sub raisinmacro section of your VBA editor.

Then attempt running it again.

Skip's code is solid. I just think you didn't know "where" or possibly "how" to place it.

HTH
--MiggyD

"If a tree falls in the forest and no one is around, does it make a sound?" I finally got the answer!

RE: Need to populate two columns based on content of adjacent two columns.

True. You can CALL a Function within a Sub.

But you can also use a Function directly in a sheet, just as you would use a spreadsheet formula, which is how I designed this Function, as you can see from my uploaded workbook.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
Thanks again Skip, and thank you Miggy for the reply. I believe you are right - I am not placing the code correctly. (I'm using Excel 2003. I'm not sure if this is a factor.)

I create a new macro labeled raisin2. The page reads:

Sub raisin2()

End Sub

Presumably, I enter the code from above (first reply to post) into the Sub space? This does not work. What am I doing wrong?

RE: Need to populate two columns based on content of adjacent two columns.

Why why why are you creating a Sub?

Can't you see my EdLow function, coded in a module, and used directly on the sheet? I uploaded your workbook with everything working as specified.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
Sorry.... I don't know. I have never created a macro before. Felt is safe to assume - go to Tools/Create New Macro etc.... enter the macro...

Yes, I see 'EdLow', but what do I do with the code? Enter it directly on the sheet?

RE: Need to populate two columns based on content of adjacent two columns.

Did you download the workbook I uploaded?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
I did. Thank you. I have it.

RE: Need to populate two columns based on content of adjacent two columns.

alt+F11 toggles between the sheet and the VBA Editor.

Do you see the Module containing the EdLow function?

Do you see in A2 & B2 for instance, how the EdLow function is used?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
Yes, I see how Alt/F11 toggles to the editor. It contains:

Sub raisin2()

End Sub


I do not see the EdLow module anywhere.


I do see, where B2 contains:
=IF(NOT(ISBLANK($C2)),IF(ISNA(MATCH(1,OFFSET($D$1,MATCH($E2,Section,0),0,COUNTIF(Section,$E2),1),0)),"cherry",""),"")

..and B3 contains:

=IF(AND(NOT(ISBLANK($C3)),$D3=0),"cherry","")

RE: Need to populate two columns based on content of adjacent two columns.

Look at the upload on 8 Nov 16 21:39.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
I'm looking at it. I see where it has formulas in A and B, underneath the SECTOR-1 and SECTOR-2 headers, for example:

=EdLow($C2,$D2,B$1)

RE: Need to populate two columns based on content of adjacent two columns.

👍

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
.. so on a sheet, I have 10,000+ rows, columns A, B, C and D, arranged in sections with the 'SECTOR' and 'DECIMAL' headers. A and B have only these header labels - no other content. Column C may or may not have a value in the cells immediately below the SECTOR-3 header. Column D has either only zeros in the cells below the DECIMAL header, or, contain at least one '1'.

I have the file you uploaded (thank you for that.) I see the formulas you entered in A and B, in the cells immediately below the SECTOR-1 and SECTOR-2 header labels.

What do I do next to apply the formulas to my sheet?

RE: Need to populate two columns based on content of adjacent two columns.

1) copy the EdLow function to a Module in your workbook, if it's not already there.

2) this formula, =EdLow($C2,$D2,B$1), should be pasted into cell B2. Them copy B2 and paste everywhere you need the results

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
I click Alt/11. The VB window opens. In it is the EdLow function.

Back to my worksheet, I enter =EdLow($C2,$D2,B$1) into a blank cell and drag it down. It creates a column of 'cherry' with spaces, at various intervals, regardless of what is in B or C.

RE: Need to populate two columns based on content of adjacent two columns.

I click Alt/11. The VB window opens. In it is the EdLow function.

There are several different objects in the VB Window, (ctrl+R): Microsoft Excel Objects, including Worksheet Objects and the ThisWorkbook Object.
There may also be a Modules Object, in which will be Modules Object(s). In one of these Modules is where your EdLow function needs to be stored (pasted). If it is anywhere else, CUT the code and PASTE into a Module.

Back to my worksheet, I enter =EdLow($C2,$D2,B$1) into a blank cell and drag it down. It creates a column of 'cherry' with spaces, at various intervals, regardless of what is in B or C.

This is incorrect! The ONLY cell that this formula can be pasted in in B2 (the references tell you where it needs to be: row 2, column B.)
Don't you mean C or D.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
Sorry- yes, I meant to say C or D above.

Alt/11 opens the editor. The pane is Modules with the module inside it so this appears correct.

OK - I enter the code =EdLow($C2,$D2,B$1) into B2.

What then? How is this then applied to the sheet?

RE: Need to populate two columns based on content of adjacent two columns.

Copy B2 and paste where ever you need.

From then on copy formula from any cell, paste or drag at will.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
I entered the formula into B2 as specified. I then copied B2 and pasted it into J2 and dragged it down 2000 rows.

Result: #NAME? appears in B2, B3, B4, B5, B6, B7, B8, B9 - and, B18, B26 - and B37, B38, B39, B40, B41, B42, B43 and B44.

I do not see how this will apply down to 10000+ rows.

RE: Need to populate two columns based on content of adjacent two columns.

Woah!

YOUR specifications! With certain data in columns C & D, return values to columns A & B!

What's with column J???

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
You said "From then on copy formula from any cell, paste or drag at will." So I used J. What column should I have used?

RE: Need to populate two columns based on content of adjacent two columns.

That deserves no reply!

Here's a modified EdLow function in this upload.

Put the formula in row 2: A & B. Then copy all the way down through all your 1000 rows of data.

Copy anywhere else if you like.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)

Thank you for your patience in helping with my post. It is appreciated. I thought for a moment that the macro worked. It returned results all the way to 9000+ rows. Then I noticed, the results were nearly all wrong - a mix of correct and incorrect returns. Sections with the same combination of B and C content would give different results. The macro is also crashing Excel (2003). Not sure why but if I open one or two more files after running the macro, the whole program comes to a screeching halt.

RE: Need to populate two columns based on content of adjacent two columns.

AHH! Therein lies the problem. You are not communicating clearly. Even I have a hard time understanding.

I am guessing you mean the content combination of C and D; not ...

Quote (Edward_Low)


... combination of B and C content would ...


If you are using your original workbook. You really shouldn't until you understand what is happening, why it works one way and not the other, and how to modify it to your needs.

Quote (Edward_Low)


1: Nothing is entered in C and there is a '1' found in column D. - RESPONSE: Enter 'orange' in column A.
2: Nothing is entered in C and there are only zeros in column D. - RESPONSE: Enter 'plum' in column A.
3: Something is entered in C and there is a '1' found in column D. - RESPONSE: Enter 'apple' in column A.
4: Something is entered in C and there are only zeros in column D. - RESPONSE: Enter 'raisin' in column A, and 'cherry' in column B.


The condition you originally posted uses calculations almost similar to an XOR function. Which I haven't use since QuickBASIC 4.6! and even then I avoided it as much as possible.

Essentially its like this **Note: I'm using Skip's cleaned-up version of your workbook from here on out.

CODE

Plum   = C + D (where: C = "" and D = 0)
Orange = C + D (where: C = "" and D = 1)
Apple  = C + D (where: C = "word" and D = 1)
Raisin = C + D (where: C = "word" and D = 0)
Cherry = Raisin (TRUE) 

If this is correct then you want something similar to the following logic:

CODE

if (C = Empty) + (D = 0) then A = Plum & B = ""
if (C = Empty) + (D = 1) then A = Orange & B = ""
if (C <> Empty) + (D = 1) then A = Apple & B = ""
if (C <> Empty) + (D = 0) then A = Raisin & B = Cherry 

Is This logic correct? Is this similar as to what you would like your code to do?
Are we on the same page now? Or am I off the mark?

LMK

--MiggyD

"If a tree falls in the forest and no one is around, does it make a sound?" I finally got the REAL answer!

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
Hi Miggy,
Thank you, and yes, I think you are on mark. I thought I was careful to avoid any misunderstanding with my post but I know how things can be misinterpreted.


Quote (MiggyD)

Plum = C + D (where: C = "" and D = 0)
Orange = C + D (where: C = "" and D = 1)
Apple = C + D (where: C = "word" and D = 1)
Raisin = C + D (where: C = "word" and D = 0)
Cherry = Raisin (TRUE)

Just to reiterate it in my words. My way of putting it is:

(Nothing and a '1' = orange.)
(Nothing and only zeros = plum.)
(Something and a '1' = apple.)
(Something and only zeros = raisin + cherry.)

By '1', I mean any number of 1s in any position. It could be just one 1, or all 1s in the section.


Another example: nothing is entered under SECTOR-3 (in a section), AND only zeros are in column D - then, 'plum' must be entered once, in the cell immediately under SECTOR-1 in column A.

Another example: Something is entered in column C under SECTOR-3, AND, column D contains a numeral '1' somewhere. Then, 'apple' must be entered in the cell immediately under SECTOR-1, column A.

Likewise for the other two possibilities.

Apologies if I was not clear on this at any point.

RE: Need to populate two columns based on content of adjacent two columns.

Please upload your workbook with 9000 rows not working.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
... 79, for example, has 'plum' (has blank in C79 and a '1' in the section, so would be 'orange').

152 has 'raisin' 'cherry', but has something in C152 and 1s in D, so would be 'apple'.

RE: Need to populate two columns based on content of adjacent two columns.

Please tell me a specific instance (row) of an incorrect result: What you get and what you expect.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
Yes, as above - 79 and 152.

RE: Need to populate two columns based on content of adjacent two columns.

79 and 152 WHAT?

What to you get?

What do you expect?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
... 79, for example, has 'plum' (has blank in C79 and a '1' in the section, so would be 'orange').

152 has 'raisin' 'cherry', but has something in C152 and 1s in D, so would be 'apple'.

RE: Need to populate two columns based on content of adjacent two columns.

Row 79
SECTOR-1	SECTOR-2	SECTOR-3	DECIMAL
orange			
 

Row 152
SECTOR-1	SECTOR-2	SECTOR-3	DECIMAL
apple           		CONTENT	
 

This is what I see. I have no idea what you are seeing!

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

What is your Calculation mode?

Automatic or Manual?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
I am using manual click & drag down, from A2 and from B2.

This is in the file I just uploaded.

Results from row 78:
SECTOR-1 SECTOR-2 SECTOR-3 DECIMAL
orange
0
0
0
0
1
0
0
0
0

.. and from 151:
SECTOR-1 SECTOR-2 SECTOR-3 DECIMAL
apple CONTENT
1
1
1
1
1
1


.. with zeros and ones being under the DECIMAL header.

RE: Need to populate two columns based on content of adjacent two columns.

Great!

So what's the problem?

You hardly ever address the questions I ask!

What about your Calculation Mode?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
My last post shows correct results. The problem is, when I ran the formula and looked at the results, the sheet did not show these results in these columns - they showed incorrect results. This is what I saw.

... 79, for example, has 'plum' (has blank in C79 and a '1' in the section, so would be 'orange').

152 has 'raisin' 'cherry', but has something in C152 and 1s in D, so would be 'apple'.


I clearly saw 'plum' in place of what should be 'orange', etc. I was looking at 79 - plum was the result, with no entry in C and a 1 in D.

I then cut and pasted 79 and 152 into my last reply which now I see are correct.

I can only conclude the macro is taking time to complete (it is a big file) - first giving erroneous results then completing with correct results. Scanning the page now, I do not see any errors. Before, they were everywhere.

RE: Need to populate two columns based on content of adjacent two columns.

It's making 18,000 calculations. It takes my Dell Inspiron about 30 seconds to finish calculating. My Excel shows a percent complete in the status along the lower margin.

Second time it took only 5 seconds.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
I know what I saw on the first run - it was about half errors. File size is only a guess as to why this occurred. Excel was crashing too. I just ran it again - looking down the rows, I see they are correct.

Thank you again for your generous help with my post! Didn't mean for it to drag out like that. I appreciate your time.


RE: Need to populate two columns based on content of adjacent two columns.

Make sure that either...

1) your Calculation Mode is Automatic or

2) you F9 (Calculate All) after a change in your sheet.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
Will certainly watch for that.

Thank you Skip!

Best....

RE: Need to populate two columns based on content of adjacent two columns.

Glad we could arrive at a satisfactory solution for you.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Need to populate two columns based on content of adjacent two columns.

Glad that's resolved.

Quote (Edward_Low)


... When I ran the formula and looked at the results, the sheet did not show these results in these columns - they showed incorrect results. This is what I saw. ... which now I see are correct.

You may want to consider getting more memory or turn off any background processes while you continue using your workbook.

Good Luck
--MiggyD

"If a tree falls in the forest and no one is around, does it make a sound?" I finally got the REAL answer!

RE: Need to populate two columns based on content of adjacent two columns.

(OP)
Thank you too Miggy for your help. I'm reasonably sure it was system memory causing the file to load erroneous results. I have a lot of apps open and lots of Excel files at once.

Thanks again for the help!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close