Posts by EstimatorJJS

I have added a new drop down in column J to do the same thing as before. Copy row to corrilating sheet.

How do I code this in as well? Please see previous comment for more details. Thank you!

Quote from Mumps

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Bids sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in column I.

Code

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Target.Column <> 9 Then Exit Sub
    Dim lRow As Long
    Application.ScreenUpdating = False
    Select Case Target.Value
        Case "PACKAGE"
            With Sheets("Package")
                lRow = .Range("B2", .Range("B" & .Rows.Count).End(xlUp)).Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
                Range("B" & Target.Row).Resize(, 7).Copy .Range("B" & lRow + 1)
            End With
        Case "CO"
            With Sheets("Change Order")
                lRow = .Range("B2", .Range("B" & .Rows.Count).End(xlUp)).Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
                Range("B" & Target.Row).Resize(, 7).Copy .Range("B" & lRow + 1)
            End With
    End Select
    Application.ScreenUpdating = True
End Sub

Display More

Now, one last thing.

If I want to add another drop down list to column J to do the same thing only to different sheets.

What portion of the code do I change to reflect that? Can you highlight were I should change the column? and where I should indicate how to copy to another sheet.

Example: I am now going to make a drop down list in column "J" that have the options : Not awarded, Awarded, Working, and Completed ready to invoice.

How do I add that in?

Thank you!

THANK YOU SO MUCH!!!!

The drop down list is on the "BIDS" sheet column "I".

The drop down list says "CO" or "PACKAGE".

If CO is selected I need the entire row to be copied and put on the change order sheet.

If package is selected I need the row to be copied to the "Package" Sheet.

Does that clarify enough? I am sorry I am new to the forum.

Hello,

I am trying to create a spread sheet that will allow for rows to be copied automatically and put into a separate sheet depending on the drop down selection.

i.e. : If "change order" is selected, I would like that row to be copied to a sheet titled Change order.

I cannot for the life of me make this work. Help?