Move or Copy Rows & Columns Using Excel VBA, Including Move to Another Sheet and Move to End of Data

This video tutorial will demonstrate how to move or copy rows and columns within a worksheet and between worksheets.

The tutorial will show you how to:
Move a row from one table to another using VBA
Move a column to the left or right using VBA
Transfer/copy data from one sheet to another using a VBA macro
Copy and paste a column
Copy a column to another worksheet
Copy and paste a row into the next empty row or last row
Move a row to the end of a table
------------------------

[BambooScar]

OMG finally someone mentioned what xlUP/Down means, i never understood what that was doing but i always manually use CTRL Up/Down/Left/Right so it made no sense, thanks!

[garymcnay]

Thanks tons...was working on this very thing for hours.

[jonbay]

Just what I needed! Created a very simple Parts list where my customers can simply click on parts of an image and it will add to a list that they can then send to me. :) Cheers

[mtstans]

very helpful good presentation: clear and concise

[ansonlaniyan]

Fantastically simplified, what if I wanna copy from column A and D OR Column A D & H? What is the separator needed to copy multiple and paste or insert

[benjiwong]

can you show the macro how to move the entire row to another worksheet?
example if the column has a status "Completed" then it moves this row to Completed sheet? thanks

[petermichael]

Thanks very much. This video was very helpful, especially the Offset feature at the end. Your code worked great for me except for one glitch. When I copy/insert values into the target columns that already have values (such as in your example), the macro works great. However, when the target columns are empty, I get a macro error. After I manually enter one row of values in the target columns, then the macro works great. BTW, my row 1 is a frozen header row, but I don't know if that makes a difference. Thanks.

[sachinchari]

What about two different rows like 7 & 10

[shareeschnoebelen]

I am trying to use this with an if scenario. Whenever I have the words completed and/or N/A in columns D through L, I want the rows to automatically move to my second sheet. How do I do that?

[wadebrewer]

Exactly what I'm trying to accomplish, I'm assembling a production schedule for current job and need to sort, then move jobs from scheduling pool to line(s) schedule. I could not see how you closed he string, can you copy the text to this comment or to your description, please? Thank you so much sir!

[ashrafulalam]

Hi,
How to copy column data where formula applied. Because I am trying copy a column data & paste into another sheet but it’s shown #Valuve doesn’t show copy the real value. Could you make a class on this topics pls. Thanks

[tulio]

How about cutting and pasting two columns to the end of the data of 2 other columns ?

[sircorn]

Hi, thanks for the video. Do you have a solution for the task: I would like to select a row, cut it, select another row and insert the cut one there? Thank you

[samdesai]

What’s the code for copying certain cells in a row rather than the whole row if a condition is met?

[Mr.Wilson]

Thanks for this video, it helped me get a better understanding of how to manipulate Excel VBA a bit more! I am trying to write a Macros for this sheet at work that is similar to what you are doing here, however, I need to shift cells or cut and paste within the same sheet. For example: I want to have an If then statement that reads something like this; =IF(A1="Sat", Shift2xDown, A1). Saying that if the cell reads Saturday, the corresponding value is moved 2 cells down in the same column with no rows over.
This is similar to the copy and paste you did at the end of the video, but would just be cut and pasted 2 rows down with the logic of the If then statement included. Is there any way that you could help with this?

[yanal]

thank you very much, this is very useful
is it possible to help me in something please?
i have a training database, of which all countries from regions send me their training progress, like 12 rows per week.
i'm noob in vba, so i tried couple of ideas and was able to search for MENA value in rows, copy it, and past it in another sheet called MENA, same as other regions. however what i have found is each time i update the database, i click update, it recopy all the MENA value (old and new) and paste it after what has been copied before in MENA sheet.
i want to have one button to update all regions, without duplication.. is that possible?

[abdulhamidalhaddadi]

sir, how can i apply this code to all my WS

[wenkiansem]

Hi, i got one issue that.
I want to copy a last cell of the column which change when ppl type.
To do that, i get the last row number by
Lrow= cells(rows.count, 1).end(xlup).row
Is it possible that i can do things like below?
Cells(Lrow, 1).copy and then paste using the same format.
I have tried many possible way to do it but still there is error

[icchung]

Hi, I was wondering how to create a VBA to copy & paste a dataset onto a new sheet. Criteria: are it has to carry over the information[COLUMN A TO B] base on the issues listed in the column. As the result the each sheet will have a column of ONE issue listed (see Results/Goal section)