SOLVED

copy row above in a worksheet

Copper 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.
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)