Compare cells in one spreadsheet to cells in 2nd spreadsheet

If you would like to get a reliable solution it is best to upload a sample workbook with no sensitive data showing how each workbook is set out and also showing the end result - please be very specific explaining the logic and show in an example sheet how the workbook looks prior to the code running and after the code runs how the result should appear. Without seeing the layout it is difficult to write a solution that will work for you. Make sure there is no sensitive/private data in the sample workbooks you upload. To attach the sample workbooks select Go Advanced, Manage Attachments and select the workbooks to upload. Welcome to Excel Forum.

You have 2 sheets in the Sample Budget update workbook - one is called Daily Status. When you say

I want to copy Column L of the DailyStatus to Column K of the BudgetUpdate

and

If there is no match, then I want to add the number from Column C of DailyStatus to the end of Column A of the BudgetUpdate.

you are talking copying data between workbooks and you are not referring to the Daily Status worksheet in the Sample Budget Workbook. Should there be a Daily Status Sheet in the Sample Budget workbook or did you just place it there for my convenience? I am assuming you want data copied between workbooks if there are matches and when there are no matches and the Daily Status worksheet in the Sample Budget workbook has no relevance to what you want the code to do. Am I correct in my assumption?

This should do what you require - I have placed a button on the Daily Status sheet of the SampleDailyStatus workbook - it will first ask you to browse to open the Budget workbook file so you only need to start with the Daily Status workbook open. Once the Budget workbook is open it will search column C of the Daily Status sheet and copy the data as per your instructions. Before you run this on any real data ensure it does what you require and make sure to back up any essential data as you cannot undo the changes made by VBA code. Remember you do not have to have the Budget Workbook open - you only need to have the Daily Status workbook open to run the code as part of the code asks you to browse to the Budget workbook.
If there are any problems or any corrections needed let me know. I have attached the workbook and code is as follows. You can use the Sample Budget workbook you sent me to test against the attached workbook as the Budget workbook does not contain any code.

Option Explicit

Sub compData()
Dim wsDs As Worksheet, dsData As Range, ds As Range, budgetData As String
Dim brWbBU As Worksheet, brWbDS As Worksheet, crBU As Range
Application.ScreenUpdating = False
   On Error GoTo compData_Error
Set wsDs = ActiveWorkbook.Worksheets("Daily Status")
Set dsData = Find_Range("*", wsDs.Range("C2:C" & wsDs.Cells(Rows.Count, "C").End(xlUp).Row), xlValues, xlWhole)
MsgBox "Open Budget Data Workbook", vbInformation
budgetData = Application.GetOpenFilename("Excel files (*.xls*),*.xls*", _
    1, "Select Budget Workbook", , False)
If budgetData <> "False" Then
Workbooks.Open (budgetData)
Else
MsgBox "No Workbook Selected - Process will now end", vbCritical
Exit Sub
End If
On Error Resume Next
Set brWbBU = ActiveWorkbook.Worksheets("Budget Update")
On Error GoTo 0
If brWbBU Is Nothing Then
MsgBox "Opened workbook does not contain Budget Update Sheet. Please open correct file"
Exit Sub
End If
For Each ds In dsData
Set crBU = Find_Range(ds, brWbBU.Range("A9:A" & brWbBU.Cells(Rows.Count, "A").End(xlUp).Row), xlValues, xlWhole)
If Not crBU Is Nothing Then
wsDs.Range(ds.Address).Offset(, 9).Copy
brWbBU.Range(crBU.Address).Offset(, 10).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
Else
wsDs.Range(ds.Address).Copy
brWbBU.Range("A" & brWbBU.Cells(Rows.Count, "A").End(xlUp).Row + 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End If
Next
Application.ScreenUpdating = True
   On Error GoTo 0
   Exit Sub
compData_Error:
    MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure compData of Module1"
End Sub

Function Find_Range(Find_Item As Variant, _
    Search_Range As Range, _
    Optional LookIn As Variant, _
    Optional LookAt As Variant, _
    Optional MatchCase As Boolean) As Range
     
    Dim c As Range, firstAdd As String
    If IsMissing(LookIn) Then LookIn = xlValues 'xlFormulas
    If IsMissing(LookAt) Then LookAt = xlPart 'xlWhole
    If IsMissing(MatchCase) Then MatchCase = False
     
    With Search_Range
        Set c = .Find( _
        What:=Find_Item, _
        LookIn:=LookIn, _
        LookAt:=LookAt, _
        SearchOrder:=xlByRows, _
        SearchDirection:=xlNext, _
        MatchCase:=MatchCase, _
        SearchFormat:=False)
        If Not c Is Nothing Then
            Set Find_Range = c
            firstAdd = c.Address
            Do
                Set Find_Range = Union(Find_Range, c)
                Set c = .FindNext(c)
            Loop While c.Address <> firstAdd
        End If
    End With
End Function

Do you want me to make those changes or are you ok to amend the code yourself?

Here is the amended code for you. Just check this is what you require.

I am glad it worked. If you are happy the problem has been finalised can you please change the thread to solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

I went back to the original workbook and had a look to refresh my memory - with what you describe it would be best if you could please supply the 2 sample sheets like you did previously as obviously the layout has changed a bit. Column A in budget update used to be a # Identifier however in Daily Status it was just Approved/Not Approved - It would be much better if I could see the data layout so I know what sort of data I am comparing - please upload sample workbooks and if you think you need to give any more explanation please be specific in what is required e.g. If there is a match/no match. Once you upload the sample workbooks I will rewrite the code for you

I am a bit confused so can you confirm
1. Search Daily Status workbook and if Number (Column A) from Budget Update is found in Number in Daily Status (Column A) then copy Column D from Daily Status to Column D of Budget Update, Column M from Daily Status to Column K of Budget Update, Column J of Daily Status to Column J of Budget Update.
2. If number is NOT found then add the all the Numbers from Daily Status to Budget Update and Add corresponding values from Column B,C,D, and J from Daily Status to Budget Update and Column M from Daily Status to Column K of Budget Update.
3. Move the totals in J-N of Budget update to last row.
Have I got that right?

I will have to update my code - I was just about to upload it - will make changes and upload soon for you.

Try the attached workbook - I have attached the code to a button for you. Let me know if the rules are correct.