This code changes my rather than the line below it that needs changed

[Nlhicks]

This line of code will take the values in wsUpdate.Range and write the results in the header row of wsUpdate instead of the line that needs to be updated.
lngLastRow = wsUpdate.Range("A" & wsUpdate.Rows.Count).End(xlUp).Row

This line of code does nothing but we were trying to find a solution.
lngLastRow = WorksheetFunction.Max(wsUpdate.Range("A" & wsUpdate.Rows.Count).End(xlUp).Row, 2)

Does anyone have a suggestion that will fix this issue?

 

[kevin9999]

Try
lngLastRow = wsUpdate.Range("A" & wsUpdate.Rows.Count).End(xlUp).Row+1

 

[Nlhicks]

Okay so what that did is change the very first line of code but my data does not live on the very first line of code it lives on a line somewhere between A2:A685. Once the data is filtered then it lives on the the second line but it is not actually the second line it is the only visible line.

 

[kevin9999]

It's impossible for me to fathom the issue without seeing the full code, a sample of your data, and a full explanation of what you're trying to achieve. If this is just a follow up to another post then perhaps a link to that would do.

 

[Nlhicks]

Run my master workbook and call another non-macro enabled workbook and do the edits to it prior to saving

 

[kevin9999]

Run my master workbook and call another non-macro enabled workbook and do the edits to it prior to saving

It looks like @HaHoBe has invested a considerable amount of time and effort to help you resolve this issue, it's only fair to let them finish to a conclusion.