VBA - add new row and copy values from cells to other cells on the new row

**varbergt** · 03-26-2024, 03:55 AM

Hi,

When clicking the "add employee" button I want to add a new row after last row. Any value in yellow cell should go to the other yellow cell and so on.
I've managed to make the VBA add a new row but struggling with the remaining part.

Any input to get me started would be appreciated.

Sample.png

Formula:

Please Login or Register  to view this content.

Best,
Thomas

**sintek** · 03-26-2024, 04:21 AM

Please Login or Register  to view this content.

**varbergt** · 03-26-2024, 05:12 AM

Wow. Awesome! Thanks a lot

**sintek** · 03-26-2024, 07:45 AM

Glad to have contributed...

VBA - add new row and copy values from cells to other cells on the new row

LinkBack

Thread Tools

Rate This Thread

Display

VBA - add new row and copy values from cells to other cells on the new row

Re: VBA - add new row and copy values from cells to other cells on the new row

Re: VBA - add new row and copy values from cells to other cells on the new row

Re: VBA - add new row and copy values from cells to other cells on the new row

Thread Information

Users Browsing this Thread

Similar Threads

help with macro Copy-paste values (merged cells to single cells)

[SOLVED] All cells to copy & paste as values Except those cells in which formulas starts with =SUM

excel using VBA how to select specefic cells based on their values and copy these cells in

Find specific cells in excel and copy to adjacent cells corresponding values

Macro which finds and copy's cells based on values in other cells.

Formula to copy and paste data in cells to other cells based on values

[SOLVED] How can I copy the values of all selected cells to the same cells inanother Sheet

Bookmarks

Bookmarks

Posting Permissions