I have a spreadsheet that I would like when clicking on a buttonsave to Open a spreadsheet called C:\Asset Tracking.

Then look at the original Spreadsheet cell K5 match with the tab.
So if K5 = NC8230 then in the "Asset Tracking" go to NC8230 tab.

Then Look at cell B6 and vlookup in the "NC8230" Tab under Range("B$5:B$500") and if there is a match update that row with the new data.

Else if not found input the new data in the next available cell in column B.

So if Cell B6 is found then in that same row make these changes

Spreadsheet 1........."Asset Tracking"
AA1.................=....Column C "what ever row it was found in"
V1...................=....Column D "what ever row it was found in"

Else If not found

Same as above just need to add
Spreadsheet 1........."Asset Tracking"
B6...................=....Column B "Next empty row"
AA1.................=....Column C "Next empty row"
V1...................=....Column D "Next empty row"

Then save and close spreadsheet.

I know this is a bit of a challenge.

Any help would be great. Thanks