Add new data on the last row of worksheet table

[omegaboost]

Dear all,

How to add the new data on the worksheets table (A1:A6) with the total in last row by click the command button? the input data are in cells J2,J3,J4,J5.

Thank you

Best Regards

Omegaboost

[JBeaucaire]

One way to do that:

Please Login or Register  to view this content.

[omegaboost]

Dear JBeaucaire,

Thank you for your reply. Your solutions is great and i will apply to my table.
Just wondering, is there any other way to fill that table beside your solution?

Thank you
Omegaboost

[JBeaucaire]

Probably 100s. Hope the one I offered suffices.

[sktneer]

Another way is this.

While dealing with an excel table, it's always better to reference that table in the code so that if you move your table on the sheet, the code will follow the table and insert the data correctly into the table.

Please Login or Register  to view this content.