I have an Excel application ("Shop.xls") which allows users to copy
Excel charts directly to a PowerPoint deck ("Shop.ppt").

At the start of the application the user selects a geography from a
drop-down and the result appears in a specific cell which is 'named'
TARGET.

I would like to program the application to automatically insert the
TARGET into the title of the corresponding PowerPoint deck. The
current title reads "An overview of shopper trends at XXX",
and I would like to set the title to read "An overview of shopper
trends at TARGET" based on whatever selection the user made up front.

Can this be done, and if so how do I write the code? Is the code
written in an Excel macro, or in a PowerPoint macro?

Many thanks..