VBScript Error Run-Time 1004

J

jhedges

Board Regular
Joined
May 27, 2009
Messages
208
Anyone,

I have been working on the following worksheet, which has A3-Z27 cells right now and will grow/shrink with time. The spreadsheet shown below is just a portion of the entire worksheet. My vbscript is below the worksheet. I have two worksheets PL Dbase and Waiting List. I am copying columns B thru G from Waiting List if Column J is = to "Yes". To the next available row in worksheet PL Dbase columns B thru G...These columns have the same headings on both worksheets. I am getting the following error, when I click the button I assigned the macro to: Run-Time Error 1004 Copy Method of Range Class Failed. Can someone help me figure out what I have wrong?

Waiting List

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: MS Sans Serif,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 124px"><COL style="WIDTH: 106px"><COL style="WIDTH: 106px"><COL style="WIDTH: 82px"><COL style="WIDTH: 59px"><COL style="WIDTH: 58px"><COL style="WIDTH: 61px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 38px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; TEXT-ALIGN: center">Status</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; TEXT-ALIGN: center">LastName</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; TEXT-ALIGN: center">FirstName</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; TEXT-ALIGN: center">Personnel #</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; TEXT-ALIGN: center">T #</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0; TEXT-ALIGN: center">Email</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; TEXT-ALIGN: center">Gender</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial">Clifton</TD><TD style="FONT-FAMILY: Arial">Sarah</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01592233</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">AU6267</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0">AU6267,</TD><TD style="FONT-FAMILY: Arial">Female</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial">Cooke</TD><TD style="FONT-FAMILY: Arial">Richard</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01085094</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Tc2023</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0">Tc2023,</TD><TD style="FONT-FAMILY: Arial">Male</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial">Drake</TD><TD style="FONT-FAMILY: Arial">Phil</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01130303</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">tz8248</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0">tz8248,</TD><TD style="FONT-FAMILY: Arial">Male</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial">Dunajski</TD><TD style="FONT-FAMILY: Arial">Kayle</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01554779</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">AJ6833</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0">AJ6833,</TD><TD style="FONT-FAMILY: Arial">Female</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Warning</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Fraticelli</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Marlene</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01559810</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Ak7775</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Ak7775,</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Female</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial">Fraticelli</TD><TD style="FONT-FAMILY: Arial">Marlene</TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0"></TD><TD style="FONT-FAMILY: Arial">Female</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="BACKGROUND-COLOR: #c0c0c0">REMOVED</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #c0c0c0">Hamilton</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #c0c0c0">Golden</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: left">01660175</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #c0c0c0"></TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #c0c0c0"></TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #c0c0c0">Female</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial">Hogben</TD><TD style="FONT-FAMILY: Arial">Peter</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01629981</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">AN6355</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0">AN6355,</TD><TD style="FONT-FAMILY: Arial">Male</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Warning</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Johnson</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Sherry</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01621769</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Bf7270</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Bf7270,</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Female</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Warning</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Kohus</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Viviana</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01564661</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Am6661</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Am6661,</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Female</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial">Linder</TD><TD style="FONT-FAMILY: Arial">Nadyne</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01134538</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">tz4597</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0">tz4597,</TD><TD style="FONT-FAMILY: Arial">Female</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Warning</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Lubanski</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Donata</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01627450</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">BF5350</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">BF5350,</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Female</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Warning</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Lucas</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Bob</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01146427</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">TQ1415</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">TQ1415,</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Male</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Warning</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Madison</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Brooke</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01649141</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">BO3232</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">BO3232,</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Female</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial">Moeller</TD><TD style="FONT-FAMILY: Arial">Pam</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01036543</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">TM3577</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0">TM3577,</TD><TD style="FONT-FAMILY: Arial">Female</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Warning</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Morgan</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Brad</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01646837</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Bn8217</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Bn8217,</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Male</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Warning</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Pepin</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Judi</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01017742</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">TV5338</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">TV5338,</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Female</TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>A4</TD><TD>=(IF((OR(Q4<8,S4="Yes")),"Warning",IF(X4="Yes","REMOVED","OK")))</TD></TR><TR><TD>F4</TD><TD>=IF(AND(E4=""),"",(E4&","))</TD></TR><TR><TD>A5</TD><TD>=(IF((OR(Q5<8,S5="Yes")),"Warning",IF(X5="Yes","REMOVED","OK")))</TD></TR><TR><TD>F5</TD><TD>=IF(AND(E5=""),"",(E5&","))</TD></TR><TR><TD>A6</TD><TD>=(IF((OR(Q6<8,S6="Yes")),"Warning",IF(X6="Yes","REMOVED","OK")))</TD></TR><TR><TD>F6</TD><TD>=IF(AND(E6=""),"",(E6&","))</TD></TR><TR><TD>A7</TD><TD>=(IF((OR(Q7<8,S7="Yes")),"Warning",IF(X7="Yes","REMOVED","OK")))</TD></TR><TR><TD>F7</TD><TD>=IF(AND(E7=""),"",(E7&","))</TD></TR><TR><TD>A8</TD><TD>=(IF((OR(Q8<8,S8="Yes")),"Warning",IF(X8="Yes","REMOVED","OK")))</TD></TR><TR><TD>F8</TD><TD>=IF(AND(E8=""),"",(E8&","))</TD></TR><TR><TD>A9</TD><TD>=(IF((OR(Q9<8,S9="Yes")),"Warning",IF(X9="Yes","REMOVED","OK")))</TD></TR><TR><TD>F9</TD><TD>=IF(AND(E9=""),"",(E9&","))</TD></TR><TR><TD>A10</TD><TD>=(IF((OR(Q10<8,S10="Yes")),"Warning",IF(X10="Yes","REMOVED","OK")))</TD></TR><TR><TD>F10</TD><TD>=IF(AND(E10=""),"",(E10&","))</TD></TR><TR><TD>A11</TD><TD>=(IF((OR(Q11<8,S11="Yes")),"Warning",IF(X11="Yes","REMOVED","OK")))</TD></TR><TR><TD>F11</TD><TD>=IF(AND(E11=""),"",(E11&","))</TD></TR><TR><TD>A12</TD><TD>=(IF((OR(Q12<8,S12="Yes")),"Warning",IF(X12="Yes","REMOVED","OK")))</TD></TR><TR><TD>F12</TD><TD>=IF(AND(E12=""),"",(E12&","))</TD></TR><TR><TD>A13</TD><TD>=(IF((OR(Q13<8,S13="Yes")),"Warning",IF(X13="Yes","REMOVED","OK")))</TD></TR><TR><TD>F13</TD><TD>=IF(AND(E13=""),"",(E13&","))</TD></TR><TR><TD>A14</TD><TD>=(IF((OR(Q14<8,S14="Yes")),"Warning",IF(X14="Yes","REMOVED","OK")))</TD></TR><TR><TD>F14</TD><TD>=IF(AND(E14=""),"",(E14&","))</TD></TR><TR><TD>A15</TD><TD>=(IF((OR(Q15<8,S15="Yes")),"Warning",IF(X15="Yes","REMOVED","OK")))</TD></TR><TR><TD>F15</TD><TD>=IF(AND(E15=""),"",(E15&","))</TD></TR><TR><TD>A16</TD><TD>=(IF((OR(Q16<8,S16="Yes")),"Warning",IF(X16="Yes","REMOVED","OK")))</TD></TR><TR><TD>F16</TD><TD>=IF(AND(E16=""),"",(E16&","))</TD></TR><TR><TD>A17</TD><TD>=(IF((OR(Q17<8,S17="Yes")),"Warning",IF(X17="Yes","REMOVED","OK")))</TD></TR><TR><TD>F17</TD><TD>=IF(AND(E17=""),"",(E17&","))</TD></TR><TR><TD>A18</TD><TD>=(IF((OR(Q18<8,S18="Yes")),"Warning",IF(X18="Yes","REMOVED","OK")))</TD></TR><TR><TD>F18</TD><TD>=IF(AND(E18=""),"",(E18&","))</TD></TR><TR><TD>A19</TD><TD>=(IF((OR(Q19<8,S19="Yes")),"Warning",IF(X19="Yes","REMOVED","OK")))</TD></TR><TR><TD>F19</TD><TD>=IF(AND(E19=""),"",(E19&","))</TD></TR><TR><TD>A20</TD><TD>=(IF((OR(Q20<8,S20="Yes")),"Warning",IF(X20="Yes","REMOVED","OK")))</TD></TR><TR><TD>F20</TD><TD>=IF(AND(E20=""),"",(E20&","))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Code: 
Option Explicit
Sub CopyBGColIYes()
Dim NR As Long, c As Range, firstaddress As String
Application.ScreenUpdating = False
NR = Sheets("PL dbase").Cells(Rows.Count, 7).End(xlUp).Row + 1
With Sheets("Waiting List").Columns(9)
  Set c = .Find("Yes", LookIn:=xlValues, lookat:=xlWhole)
  If Not c Is Nothing Then
    firstaddress = c.Address
    Do
      Sheets("Waiting List").Range("B" & c.Row & ":G" & c.Row).Copy Sheets("PL dbase").Range("B" & NR)
      NR = NR + 1
      Set c = .FindNext(c)
    Loop While Not c Is Nothing And c.Address <> firstaddress
  End If
End With
Sheets("PL dbase").Select
Application.ScreenUpdating = True
End Sub
 
Last edited:
Sort by date Sort by votes
Hi,

Could you run the Test1 subroutine shown below and inform what a message is appeared:

Rich (BB code): 

Sub Test1()
 
  Dim c As Range, x As Range
  Const NR = 92
  On Error Resume Next
 
  ' Check if sheet "Waiting List" exists
  With Sheets("Waiting List"): End With
  If Err <> 0 Then MsgBox "Sheets(""Waiting List"") not found", vbCritical, "Error in sheet name": Exit Sub
 
  ' Check if sheet "PL dbase" exists
  Err.Clear
  With Sheets("PL dbase"): End With
  If Err <> 0 Then MsgBox "Sheets(""PL dbase"") not found", vbCritical, "Error in sheet name": Exit Sub
 
  ' Check if sheet "PL dbase" is protected
  If Sheets("PL dbase").ProtectContents = True Then MsgBox "The contents of ""PL dbase"" are protected", vbCritical, "Error": Exit Sub
 
  'Check the source range
  Err.Clear
  Set c = Sheets("Waiting List").Cells(9, 4)
  With Sheets("Waiting List").Range("B" & c.Row & ":G" & c.Row): End With
  If Err <> 0 Then MsgBox "Error in addressing to 4th row of ""Waiting List"" sheet", vbCritical, "Error": Exit Sub
 
  'Check the destination range
  Err.Clear
  With Sheets("PL dbase").Range("B" & NR): End With
  If Err <> 0 Then MsgBox "Error in addressing to B" & NR & " cell of ""PL dbase"" sheet", vbCritical, "Error": Exit Sub
 
  'Check if the source range is merged
  Err.Clear
  With Sheets("Waiting List").Range("B" & c.Row & ":G" & c.Row)
    For Each x In .Cells
      If x.MergeCells Then MsgBox "Sheets(""Waiting List"") has merged cell " & x.Address, vbCritical, "Error": Exit Sub
    Next
  End With
 
  'Check if the destination range is merged
  Err.Clear
  With Sheets("PL dbase").Range("B" & NR).Resize(, 6)
    For Each x In .Cells
      If x.MergeCells Then MsgBox "Sheets(""PL dbase"") has merged cell " & x.Address, vbCritical, "Error": Exit Sub
    Next
  End With
 
  'Check if the source range can be copied
  Err.Clear
  With Sheets("Waiting List").Range("B" & c.Row & ":G" & c.Row)
    .Copy
    Application.CutCopyMode = False
    If Err <> 0 Then MsgBox "Source in Sheets(""Waiting List"") can't be copied", vbCritical, "Error": Exit Sub
    .Copy Sheets("PL dbase").Range("B" & NR)
    If Err <> 0 Then MsgBox "Don't known reason of the fault", vbCritical, "Error": Exit Sub
  End With
End Sub

Vladimir
 
Last edited:
Upvote 0

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Vladimir,

I get a error window stating "Don't known reason of the fault". I had to do a double take in reading this error message and yes it displays exactly as I have typed it in quotes.

Thanks
Jason
 
Upvote 0
Jason

As I mentioned on my email it is caused by the merged cells you have on sheet 'PL dbase' - these reside in row 92 (where you have your control buttons). Should your code be inserting new rows in this sheet before it pastes the data in? (Otherwise you are trying to overwrite the button cells)
 
Upvote 0
jhedges said:
Vladimir,

I get a error window stating "Don't known reason of the fault". I had to do a double take in reading this error message and yes it displays exactly as I have typed it in quotes.

Thanks
Jason
Click to expand...
Jason,

Try this modification of you line of code:

Sheets("Waiting List").Range("B" & c.Row & ":G" & c.Row).Copy Sheets("PL dbase").Range("B" & NR).Resize(, 6)

What is your version of Excel?

Vladimir
 
Upvote 0
Richard,

I absolutely forgot all about those merged cells - in row 92. Thanks for catching that and I really appreciate your expertise. Sometimes it is the littlest things that you do, that cause the whole ship to sink ;).

Thanks
Jason
 
Upvote 0
Jason,
The test1 code was modified for merged cells, please try it (modified above) again.
Vladimir
 
Upvote 0
Vladimir,

Richard was able to determine that I had merged cells in the row VBA was trying to paste the data. It seems to be working now...

Thanks
Jason
 
Upvote 0
Richard,

I do have another question...my data in the PL Dbase is in a List ( excel menu - data>list>create list).

When the data is copied over from the waiting list, it is inserted into the next available row outside the list. Can the data be transfered to the next available row inside the list?

Thanks
Jason
 
Upvote 0
I don't have xl2003 to test with at the monet (only 2002 at work) but I would have thought (perhaps incorrectly) that the list would update when you added information to the bottom of it. I will have to check on what is happening when I get home tonight. (Or, to get a speedier response, you may want to post an entirely new question about this to the board - you can always refer back here if you need, but all you really want is the code you are using (in the first post) and mention about the lists).
 
Upvote 0
Richard,

This is the waiting list spreadsheet, notice Julie has column I set to "Yes"

Waiting List

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: MS Sans Serif,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 124px"><COL style="WIDTH: 106px"><COL style="WIDTH: 106px"><COL style="WIDTH: 82px"><COL style="WIDTH: 59px"><COL style="WIDTH: 58px"><COL style="WIDTH: 61px"><COL style="WIDTH: 75px"><COL style="WIDTH: 96px"><COL style="WIDTH: 102px"><COL style="WIDTH: 68px"><COL style="WIDTH: 80px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial">Shawki</TD><TD style="FONT-FAMILY: Arial">Araz</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01503766</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">tz0105</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0">tz0105,</TD><TD style="FONT-FAMILY: Arial">Male</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: right">6/22/2009</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Assigned</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: right">6/29/2009</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0; TEXT-ALIGN: right">37</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Warning</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Simons</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Jeff</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01049149</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Ty0054</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Ty0054,</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Male</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right">6/17/2009</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">Assigned</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">Yes</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right">6/30/2009</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right">42</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial">Spragg</TD><TD style="FONT-FAMILY: Arial">Mark</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">03301962</TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0"></TD><TD style="FONT-FAMILY: Arial">Male</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: right">4/17/2009</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Assigned</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: right">7/14/2009</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0; TEXT-ALIGN: right">103</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Warning</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Whitten</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Julie</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01045237</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Tl6451</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Tl6451,</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Female</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right">6/12/2009</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right">6/29/2009</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right">47</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial"></TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial"></TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial"></TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0"></TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>A25</TD><TD>=(IF((OR(Q25<8,S25="Yes")),"Warning",IF(X25="Yes","REMOVED","OK")))</TD></TR><TR><TD>F25</TD><TD>=IF(AND(E25=""),"",(E25&","))</TD></TR><TR><TD>L25</TD><TD>=IF(AND(I25="yes",TODAY()-H25>=365),"",TODAY()-H25)</TD></TR><TR><TD>A26</TD><TD>=(IF((OR(Q26<8,S26="Yes")),"Warning",IF(X26="Yes","REMOVED","OK")))</TD></TR><TR><TD>F26</TD><TD>=IF(AND(E26=""),"",(E26&","))</TD></TR><TR><TD>L26</TD><TD>=IF(AND(I26="yes",TODAY()-H26>=365),"",TODAY()-H26)</TD></TR><TR><TD>A27</TD><TD>=(IF((OR(Q27<8,S27="Yes")),"Warning",IF(X27="Yes","REMOVED","OK")))</TD></TR><TR><TD>F27</TD><TD>=IF(AND(E27=""),"",(E27&","))</TD></TR><TR><TD>L27</TD><TD>=IF(AND(I27="yes",TODAY()-H27>=365),"",TODAY()-H27)</TD></TR><TR><TD>A28</TD><TD>=(IF((OR(Q28<8,S28="Yes")),"Warning",IF(X28="Yes","REMOVED","OK")))</TD></TR><TR><TD>F28</TD><TD>=IF(AND(E28=""),"",(E28&","))</TD></TR><TR><TD>L28</TD><TD>=IF(AND(I28="yes",TODAY()-H28>=365),"",TODAY()-H28)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4


Here is the PL Dbase after I have run the macro to copy the data from the Waiting List to PL Dbase. The space above the yellow text is the list inserting a new row; however, as you can see the data is being inserted just below the list. The Excel Jeanie is not showing the blue line around the list...

PL Dbase

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: MS Sans Serif,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 123px"><COL style="WIDTH: 106px"><COL style="WIDTH: 106px"><COL style="WIDTH: 89px"><COL style="WIDTH: 52px"><COL style="WIDTH: 55px"><COL style="WIDTH: 64px"><COL style="WIDTH: 61px"><COL style="WIDTH: 55px"><COL style="WIDTH: 80px"><COL style="WIDTH: 76px"><COL style="WIDTH: 72px"><COL style="WIDTH: 59px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">88</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Witte</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Sherry</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01101857</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">tv8822</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0; TEXT-ALIGN: left">tv8822,</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Female</TD><TD style="FONT-FAMILY: Tms Rmn; TEXT-ALIGN: left">MBC</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">F26</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">No</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Inside</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">89</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Yeh</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Chyon-Hwa</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01059179</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">tm7371</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0; TEXT-ALIGN: left">tm7371,</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Female</TD><TD style="FONT-FAMILY: Tms Rmn; TEXT-ALIGN: left">MBC</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">F98</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">No</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Inside</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">90</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Young</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Lynda</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01014099</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">tk6650</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0; TEXT-ALIGN: left">tk6650,</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Female</TD><TD style="FONT-FAMILY: Tms Rmn; TEXT-ALIGN: left">MBC</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">F64</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">No</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Inside</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">91</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #008000">OK</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Zorich</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Nora</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">01050065</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">tk7931</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0; TEXT-ALIGN: left">tk7931,</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Female</TD><TD style="FONT-FAMILY: Tms Rmn; TEXT-ALIGN: left">MBC</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">F54</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: center">Yes</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Inside</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">92</TD><TD></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #a6caf0"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Tms Rmn"></TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ff0000"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial"></TD><TD style="FONT-FAMILY: Arial"></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">93</TD><TD></TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Whitten</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Julie</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">01045237</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Tl6451</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Tl6451,</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffff00">Female</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">94</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>A88</TD><TD>=(IF((OR(Q88<8,S88="Yes")),"Warning",IF(Y88="Yes","REMOVED","OK")))</TD></TR><TR><TD>F88</TD><TD>=IF(AND(E88=""),"",(E88&","))</TD></TR><TR><TD>A89</TD><TD>=(IF((OR(Q89<8,S89="Yes")),"Warning",IF(Y89="Yes","REMOVED","OK")))</TD></TR><TR><TD>F89</TD><TD>=IF(AND(E89=""),"",(E89&","))</TD></TR><TR><TD>A90</TD><TD>=(IF((OR(Q90<8,S90="Yes")),"Warning",IF(Y90="Yes","REMOVED","OK")))</TD></TR><TR><TD>F90</TD><TD>=IF(AND(E90=""),"",(E90&","))</TD></TR><TR><TD>A91</TD><TD>=(IF((OR(Q91<8,S91="Yes")),"Warning",IF(Y91="Yes","REMOVED","OK")))</TD></TR><TR><TD>F91</TD><TD>=IF(AND(E91=""),"",(E91&","))</TD></TR><TR><TD>F93</TD><TD>=IF(AND(E93=""),"",(E93&","))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Adding a custom message.
Replies
1
Views
444
Micron
M
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
849
gvsumich
G
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
J
  • Question
Outlook Hypperlink of fila in email body will not open
Replies
1
Views
451
josros60
J

Forum statistics

Threads
1,215,335
Messages
6,124,326
Members
449,155
Latest member
ravioli44

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top