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!
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
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
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
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
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.
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!
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?
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
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?
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?
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
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) I posted this issue on MS community: answers.microsoft.com/en-us/msoffice/forum/all/copy-sheet-and-remove-specific-columns-repeat/95b9701b-262d-4b40-883d-afd63dc84f83
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!
very helpful thank you
Thanks tons...was working on this very thing for hours.
very helpful good presentation: clear and concise
Love your videos!
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
thank you
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
Thanx
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
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
How about cutting and pasting two columns to the end of the data of 2 other columns ?
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.
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!
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?
i also want the same , please let me know if u have solution
Does this work with tables?
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
What’s the code for copying certain cells in a row rather than the whole row if a condition is met?
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?
sir, how can i apply this code to all my WS
What about two different rows like 7 & 10
Please share sample sheet.
how about to another workbook?
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?
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
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)
I posted this issue on MS community: answers.microsoft.com/en-us/msoffice/forum/all/copy-sheet-and-remove-specific-columns-repeat/95b9701b-262d-4b40-883d-afd63dc84f83