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

preview_player
Показать описание
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
------------------------
Рекомендации по теме
Комментарии
Автор

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!

BambooScar
Автор

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

garymcnay
Автор

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

jonbay
Автор

very helpful good presentation: clear and concise

mtstans
Автор

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

ansonlaniyan
Автор

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

benjiwong
Автор

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.

petermichael
Автор

What about two different rows like 7 & 10

sachinchari
Автор

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?

shareeschnoebelen
Автор

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!

wadebrewer
Автор

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

ashrafulalam
Автор

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

tulio
Автор

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

sircorn
Автор

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

samdesai
Автор

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?

Mr.Wilson
Автор

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?

yanal
Автор

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

abdulhamidalhaddadi
Автор

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

wenkiansem
Автор

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)

icchung
visit shbcf.ru