SOLVED

copy row above in a worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2446023%22%20slang%3D%22en-US%22%3Ecopy%20row%20above%20in%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2446023%22%20slang%3D%22en-US%22%3E%3CP%3EHI%2C%26nbsp%3BI'm%20new%20here%20and%20looking%20for%20some%20assistance.%3CFONT%20face%3D%22inherit%22%3E%26nbsp%3BI'm%20constructing%20a%20excel%20workbook%20as%20work%20tracker%20for%20my%20team%20which%20can%20report%20back%20the%20necessary%20information%20as%20needed.%20I%20have%20created%20everything%20I%20need%20the%20only%20issue%20I'm%20having%20is%20that%20I%20don't%20want%20to%20fill%20a%20%3C%2FFONT%3Ecolumn%3CFONT%20face%3D%22inherit%22%3E%26nbsp%3Bwith%20the%20formulas%20(due%20to%20storage%20space%20issues%20and%20how%20the%20workbook%20will%20be%20used).%20What%20I%20would%20like%20to%20do%20is%20that%20is%20that%20once%20a%20row%20is%20complete%20the%20next%20row%20down%20then%20populates%20with%20all%20the%20necessary%20%3C%2FFONT%3Eformulas.%20I%20have%20done%20bit%20of%20fudge%20with%20sheet's%20code%20and%20when%20double%20left%20clicking%20it%20will%20create%20new%20row%20with%20all%20the%20necessaries.%20I%20just%20want%20to%20know%20if%20there%20is%20another%20way%20I%20can%20do%20this%20without%20amending%20the%20sheet%20code.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2446023%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-2446176%22%20slang%3D%22en-US%22%3ERe%3A%20copy%20row%20above%20in%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2446176%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1077945%22%20target%3D%22_blank%22%3E%40Kilnerb1300%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EAs%20variant%20that%20could%20be%20structured%20tables%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Foverview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOverview%20of%20Excel%20tables%20-%20Office%20Support%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

HI, I'm new here and looking for some assistance. I'm constructing a excel workbook as work tracker for my team which can report back the necessary information as needed. I have created everything I need the only issue I'm having is that I don't want to fill a column with the formulas (due to storage space issues and how the workbook will be used). What I would like to do is that is that once a row is complete the next row down then populates with all the necessary formulas. I have done bit of fudge with sheet's code and when double left clicking it will create new row with all the necessaries. I just want to know if there is another way I can do this without amending the sheet code. 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Kilnerb1300 
As variant that could be structured tables Overview of Excel tables - Office Support (microsoft.com)

Thank you. I knew it would be something simple like that.