Columns repeat on different sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2503739%22%20slang%3D%22en-US%22%3EColumns%20repeat%20on%20different%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2503739%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%26nbsp%3B%20I%20want%20to%20have%20the%20first%20two%20colums%20of%20the%20front%20sheet%20repeat%20on%20all%20of%20the%20subsequent%20sheets.%26nbsp%3B%20How%20do%20I%20make%20this%20happen%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2503739%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2504413%22%20slang%3D%22en-US%22%3ERe%3A%20Columns%20repeat%20on%20different%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2504413%22%20slang%3D%22en-US%22%3ECould%20you%20just%20link%20the%20cells%3F%20So%20in%20your%20second%20sheet%20have%20A1%20be%20%3DSheet1!A1%20and%20A2%20be%20%3DSheet1!A2%20and%20so%20on%3F%20Do%20they%20need%20to%20be%20dynamic%3F%20Copy%20and%20pasting%20would%20be%20easier.%20You%20can%20highlight%20(control%20click)%20multiple%20sheets%20to%20make%20changes%20to%20multiple%20sheets%20btw.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi.  I want to have the first two colums of the front sheet repeat on all of the subsequent sheets.  How do I make this happen?  

Thank you in advance.  

1 Reply
Could you just link the cells? So in your second sheet have A1 be =Sheet1!A1 and A2 be =Sheet1!A2 and so on? Do they need to be dynamic? Copy and pasting would be easier. You can highlight (control click) multiple sheets to make changes to multiple sheets btw.