Home

Linking 2 workbooks with name change

%3CLINGO-SUB%20id%3D%22lingo-sub-810541%22%20slang%3D%22en-US%22%3ELinking%202%20workbooks%20with%20name%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810541%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day.%3C%2FP%3E%3CP%3EI%20am%20hoping%20to%20link%202%20workbooks.%3C%2FP%3E%3CP%3EWorkbook%201%20is%20the%20source%20and%202%20is%20destination.%20This%20works%20perfectly%20when%20I%20set%20up%20as%20master.%20Workbook%202%20reads%20from%20workbook%201.%3C%2FP%3E%3CP%3EHowever%2C%20i%20need%20a%20way%20to%20constantly%20make%20different%20name%20changes%20to%20workbook%201.%20Each%20time%20the%20workbook%20needs%20to%20be%20saved%20with%20a%20new%20name.%20It%20will%20change%20from%20Master%20to%20eg%20smith%20then%20jones.%3C%2FP%3E%3CP%3EObviously%20with%20standard%20set%20up%20the%20Workbook%202%20no%20longer%20reads%20from%20these%20with%20a%20name%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20to%20do%20this%20so%20I%20always%20have%20a%20secondary%20workbook%202%20reading%20from%20workbook%201%20with%20new%20name%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emany%20thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-810541%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Ali_1205
Occasional Visitor

Good day.

I am hoping to link 2 workbooks.

Workbook 1 is the source and 2 is destination. This works perfectly when I set up as master. Workbook 2 reads from workbook 1.

However, i need a way to constantly make different name changes to workbook 1. Each time the workbook needs to be saved with a new name. It will change from Master to eg smith then jones.

Obviously with standard set up the Workbook 2 no longer reads from these with a name change.

 

Is there anyway to do this so I always have a secondary workbook 2 reading from workbook 1 with new name?

 

many thanks

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies