Linking Data

%3CLINGO-SUB%20id%3D%22lingo-sub-2046634%22%20slang%3D%22en-US%22%3ELinking%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2046634%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20attached%20file%20before%20reading%3C%2FP%3E%3CP%3EI%20have%20started%20an%20excel%20course%20and%20I%20am%20struggling%20on%20a%20data%20linking%20task.%20I%20know%20how%20to%20link%20standard%20data%20to%20different%20tabs%2Cworkbooks%20etc.%20There%20are%203%20separate%20worksheets%2C%20the%20annual%20sales%20figures%20have%20their%20own%20sheet.%20The%20task%20is%20to%20link%20Year%201s%20data%20to%20Year%202%20but%20increase%20by%20a%20specific%20percentage%2C%20they%20said%20it%20can%20be%20done%20manually%20however%20there%20is%20a%20quicker%2Fefficient%20way%20of%20doing%20it%20by%20linking.%20(please%20note%20the%20percentages%20are%20in%20a%20summary%2Finput%20table%20for%20you%20to%20link%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2046634%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2046690%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2046690%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F923766%22%20target%3D%22_blank%22%3E%40KatieDee%3C%2FA%3E%26nbsp%3BLook%20in%20the%20sheet%20for%20Year%203.%20The%20formulae%20in%20that%20sheet%20(F4%20and%20F5)%20link%20to%20Year%202%20and%20the%20parameters%20from%20the%20Summary%20sheet.%20I%20guess%20you%20need%20to%20do%20something%20similar%20in%20Year%202%20to%20link%20it%20to%20Year%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi All,

 

Please see attached file before reading

I have started an excel course and I am struggling on a data linking task. I know how to link standard data to different tabs,workbooks etc. There are 3 separate worksheets, the annual sales figures have their own sheet. The task is to link Year 1s data to Year 2 but increase by a specific percentage, they said it can be done manually however there is a quicker/efficient way of doing it by linking. (please note the percentages are in a summary/input table for you to link data.

 

 

3 Replies

@KatieDee Look in the sheet for Year 3. The formulae in that sheet (F4 and F5) link to Year 2 and the parameters from the Summary sheet. I guess you need to do something similar in Year 2 to link it to Year 1.

@Riny_van_Eekelen Hi there, thank you for your reply. I am aware of the linking formulas however, my task is to use the linking shortcut, meaning I don't have to manually type all of formulas. I am unsure how to link the percentages to increase the figures on Year 2 and 3.

@KatieDee What's a "linking shortcut"? Perhaps they mean to use named ranges.