getting a cell in Excel to populate the metadata field

[helwel]

sharepoint 2013 and excel 2010
if i go to File -> Info -> Properties -> Show Document Panels
i have metadata of Title: PostGrad:
if i key in ttt to PostGrad metadata and save and close Excel, back on sharepoint page i see ttt in PostGrad column. so i know the communication is there.

what i want to do is pick up info in A1 cell to get loaded to PostGrad metadata and then show in sharepoint
i have thanks keyed into A1
i renamed A1 as PostGrad (just to try same name as sharepoint)
i have File -> Info -> Properties -> Advanced Properties
under the Custom tab i have a "linked" symbol in front of PostGrad (name) thanks (value) text

how do i get the data in cell A1 to present itself in PostGrad metadata shown at top of excel form and then show in sharepoint.

 

[helwel]

the above code doesnot update the metadata field to show in sharepoint.
further researching i found someone posted macros when the above doesn't update.
here are the macros: Private Sub Worksheet_Change(ByVal Target As Range)
if Target.Address = Range("rngProcent").Address Then
'Update the value of the hardcoded custom property to match that of
'the linked custom property...
ActiveWorkbook.CustomDocumentProperties("Procent").Value = Range("rngProcent1")
end if
end sub

and sub Rectangle1_Click()
ActiveWorkbook.CustomDocumentProperties("Procent_1").Value = Range("rngProcent1")
end sub

i have changed the names in the quotes to PostGrad (what i had renamed A1 cell)
i have used each of the above on their own macro and even appended the first to a macro i already have for the sheet
NONE of the above worked to update my Document Information Panel PostGrad field in the excel (to eventually show in sharepoint when closing the excel)

 

[brentcook]

I think you found a solution to a problem I'm having. Can you explain the range and what procent is. Let me explain. I want "admitdate" cell value to be insert into "Admit Date" metadata property. Can you help me understand how that works in your code?

Thanks for posting a solution. It is really helpful when that is done and appreciate how intentional you were in trying to help people.