Home

Add Rows and automatically change and add number

%3CLINGO-SUB%20id%3D%22lingo-sub-830316%22%20slang%3D%22en-US%22%3EAdd%20Rows%20and%20automatically%20change%20and%20add%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830316%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20doing%20an%20application%20for%20Autocad%20and%20I%20want%20to%20learn%20anything%20about%20that.%20If%20I%20insert%20new%20row%20like%20photo%20that%20how%20can%20I%20automatically%20add%20numbers%20or%20formulas%20and%20change%20its%20like%20right%20side%20%3F%20I%20want%20to%20just%20add%20new%20row%20and%20it%20is%20automatically%20fill.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129270i0AC37BC637D44942%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Ekran%20Resmi%202019-08-30%2000.17.13.png%22%20title%3D%22Ekran%20Resmi%202019-08-30%2000.17.13.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129271i423CE37FD9F1906B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Ekran%20Resmi%202019-08-30%2000.18.20.png%22%20title%3D%22Ekran%20Resmi%202019-08-30%2000.18.20.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-830316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-830591%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20Rows%20and%20automatically%20change%20and%20add%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830591%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F400692%22%20target%3D%22_blank%22%3E%40bedyr%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethe%20easiest%20way%20to%20achieve%20what%20you%20describe%20is%20without%20programming.%20You%20can%20use%20an%20Excel%20Table%20for%20your%20data%20table%20on%20the%20left%20and%20use%20a%20formula%20to%20calculate%20the%20row%20number.%20In%20an%20Excel%20Table%2C%20all%20formulas%20are%20automatically%20applied%20to%20a%20new%20row.%20To%20turn%20your%20data%20into%20a%20table%2C%20use%20the%20command%20Insert%20%26gt%3B%20Table.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20table%20on%20the%20right%20is%20also%20using%20formulas%2C%20you%20can%20integrate%20it%20into%20the%20existing%20table.%20At%20the%20moment%20I%20can't%20see%20the%20logic%20that%20leads%20to%20the%20number%20in%20the%20right%20hand%20side%20table.%20Can%20you%20explain%20what%20you%20expect%20to%20happen%20there%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-830664%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20Rows%20and%20automatically%20change%20and%20add%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830664%22%20slang%3D%22en-US%22%3E%3CP%3Eon%20the%20right%20side%20that%20I%20have%20Autocad%20coordinate.%20If%20I%20insert%20new%20row%2C%20I%20have%20to%20add%20new%20coordinate%20to%20new%20row%20and%20change%20all%20them.%20I%20want%20to%20do%20that%20automatically.%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
bedyr
New Contributor

Hi, I am doing an application for Autocad and I want to learn anything about that. If I insert new row like photo that how can I automatically add numbers or formulas and change its like right side ? I want to just add new row and it is automatically fill.

 

 

Ekran Resmi 2019-08-30 00.17.13.pngEkran Resmi 2019-08-30 00.18.20.png

2 Replies

Hello @bedyr ,

 

the easiest way to achieve what you describe is without programming. You can use an Excel Table for your data table on the left and use a formula to calculate the row number. In an Excel Table, all formulas are automatically applied to a new row. To turn your data into a table, use the command Insert > Table.

 

If the table on the right is also using formulas, you can integrate it into the existing table. At the moment I can't see the logic that leads to the number in the right hand side table. Can you explain what you expect to happen there?

Highlighted

on the right side that I have Autocad coordinate. If I insert new row, I have to add new coordinate to new row and change all them. I want to do that automatically.     @Ingeborg Hawighorst 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies