Macro to move a selected row from one table to another table

**heyryy** · 12-05-2018, 12:29 AM

Hey,

I have a sheet ("TEST") and two tables on that sheet ("AC) and ("CC"). Columns widths are the same, and one table ("AC") is just above the other table ("CC")
I have a button that when clicked needs to move the row I select from ("AC") to a new row at the bottom of another table ("CC").

Note I said move, not copy, as I don't wish to have duplicate rows.

Any help would be great!

Excel 2016

**PCI** · 12-05-2018, 12:33 AM

Please attach a short excel sample of your data

**heyryy** · 12-05-2018, 01:33 AM

Here you are. Thanks!

**PCI** · 12-05-2018, 03:06 AM

What sort of button you have or wish to have ?
Why not a shortkey on the keyboard

**heyryy** · 12-05-2018, 03:07 AM

A cell that they can press is sufficient.

Ryan

**PCI** · 12-05-2018, 07:33 AM

See next code
Assign macro to a key, in file attached use Control + a to launch the macro

Please Login or Register  to view this content.

**heyryy** · 12-05-2018, 09:14 AM

Thanks for this. Almost perfect!

Just two 'small' things:

1. How to delete the original row?
2. When the row is copied to the new table, can it copy the row width too?

**PCI** · 12-05-2018, 09:42 AM

1. How to delete the original row?
See next code

Please Login or Register  to view this content.

Next point to come

**PCI** · 12-05-2018, 09:55 AM

Finally see last code

Please Login or Register  to view this content.

**heyryy** · 12-05-2018, 10:32 AM

Fantastic, thanks!

**PCI** · 12-05-2018, 12:20 PM

You are welcome
Enjoy Excel

Macro to move a selected row from one table to another table

LinkBack

Thread Tools

Rate This Thread

Display

Macro to move a selected row from one table to another table

Re: HELP: Macro to move a selected row from one table to another table

Re: HELP: Macro to move a selected row from one table to another table

Re: HELP: Macro to move a selected row from one table to another table

Re: HELP: Macro to move a selected row from one table to another table

Re: HELP: Macro to move a selected row from one table to another table

Re: HELP: Macro to move a selected row from one table to another table

Re: HELP: Macro to move a selected row from one table to another table

Re: Macro to move a selected row from one table to another table

Re: Macro to move a selected row from one table to another table

Re: Macro to move a selected row from one table to another table

Thread Information

Users Browsing this Thread

Similar Threads

Query on how to find values from original table not in a selected table.

From a selected line in a chart i want to filter a table or pivot table

[SOLVED] table(A) as an array using all rows but only selected columns to compare with table(B)

[SOLVED] Lines move from table to anothre table with the function small

[SOLVED] Code to move data from an entry table to a historical table by date.

[SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table

[SOLVED] Macro to move a row from one table to another

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions