Code to read a number from another workbook, add 1 to it then record the new number

[dpaton05]

I have tried to write some code but it won't work. I want the code to get the last number in column A of the sheet "Reference", file name: client_list.xlsm and add a 1 to it. I then want the new number inserted in the row under that row in column A. I also want the new number inserted in cell H5 of NPSS_quote_sheet within the workbook that the code is running from.

Can someone help me with the vba code please?

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1108220-need-way-creating-reference-number.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.