Thank you very much, it was exactly what i needed!

Thank you! Say you have a sheet with 20 rows, first 7 are heading for product codes, names and quantities. In the following rows, you want to input a quantity for an order. In the quantity column, you input a value (order amount)i in only half of the rows because not every item needs to be ordered. Do you use this formula so that only the rows that you enter a value in (an order amount) show up in another sheet copying the rows with the order value?

YES, It works. Really good for new learners who wants to begin VBA Excel 👍👍👌👌

Finally, a competently explained video!

I am a beginner of VBA, and can understand almost all your explanation. Well done! Described.

Can we protect only copy option in excel sheet for specific range (ctr +c option)

Hi, thank you for sharing this video. I have a question, if we want to use same macro for 2 different workbooks having different values, different number of rows but, there is one common value say in B1 (Items) for both the workbooks. Say, I use filter to sort out Items in B1 and copy the data of different items in separate new excel sheets. Is it possible?

Thanks this was very useful, I adapted it for copying only matching columns to destination sheet

Fantastic, very easy description !!! Thank You

This is such a great tutorial and exactly what I needed. How can I add onto this VBA to delete the row I just copied and pasted onto sheet 2 from sheet 1? And, how can I be sure I'm only pasting it 1 time (no duplicates)? Thank you!!

Brilliant! Thank you for this! So helpful. Is there a way to adjust the code so that I can add more rows to Sheet1, click on the Command Button and NOT have it recopy the previously entered rows? I hope that makes sense. I would like to be able to add more rows and only copy the new rows to the designated sheet. Or is there a function that will automatically filter the entire row to a new sheet based on the value of a certain cell in that row?

Question: I have one column that the values include "Morning'", "Noon", or "Evening" shifts. I would like to copy the rows of those employees that are in the "Morning" or "Evening" Shifts from one sheet to another, if either or these conditions are met using the looping concept such as the one above video example you have. Thank you :)

This is a fabulous code, I have been using offset to go to the next available row, this vba code is much better.... thanks.

Excellent code. Works great! Thank you.

hi There, u code is working well, but how to stop it duplicate every time i click command bar?

Thank you sir. It is very useful I used this for cut and paste. But sheet1 has blank cells. How can I remove that blank cell automatically.

THIS is Awesome! Do you happen to know if it will find specific texts (Key words) with the cell?

Can you help me with coding something please? I have 3 independent cells that are updated automatically, i want to copy and paste these 3 cells as value in a table that has every day of the month, and if i change the date for example to few days ago, i want the macro to take the values of the 3 cells and paste it on the table and on the row that has the matching date of the reading Thank you

Hello! Can you help me on this? This is regarding stock trading. If a cell value is 'sell or buy' then it should automatically record the stock's (live current price). And after a while when 'sell or buy' disappears (cell value is empty) it records the changed current price into another cell beside previous record. For example suppose the price keeps changing over a period of time, lets say cell A1 value is Sell/Buy and the price (Cell B1) is 235, so it records 235 and put it in cell C1. After some time if the A1 is empty and B1 value is 200, then it should paste 200 in D1. That means we will have two price C1=235 and D1=200. It should be automated "No button to click" via macro. Is it possible? Thanks!

Your tutorial is very helpful. But I have a small problem, when i update the master worksheet and then after I click the button it will going to copy all the data again, I wanted to stop that and copy the new records only when i click the button every time i update the master sheet. Can you help me to do that.

This is great - very helpful. I was able to kind of apply it to an issue I'm trying to resolve, but need the data to be pasted into a table on a different sheet. Is there an easy way to modify this code to do that?

Perfect! Excellent video Sir. Keep up the good work. It solved my problem. Thanks

How should the code be modified so that it only adds rows from Sheet1 to Sheet2 if they have not previously already been added? E.g. could it check to see if the Emp ID already exists on Sheet2 and if yes then to not copy that row again, but move on to the next one and check again before copying?

Thank you so much!!! I've been trying to do this all day. Your tutorial worked perfectly!

wonderful explanation! thank you so much for sharing your knowledge!

2 years before I saw your very valuable video. For nearly 10 days, I am searching this video. Thanking God to give me this link. Many Thanks to you for posting this valuable video.

I have excell sheet where in column D i need to restrict the characters limitations to 40 only when copy and paste some data from any excel sheet in any cell in this column also when typing in same column more than 40 characters a pop up warning msg displayed and prevent the paste action as well as preventing the typing action

This is the first time I've used VBA and it worked great. I created a command button that will run all three of my functions at once. Can I hide the three original buttons so only the new combined command button is visible? Is there a way to keep it from recopying previously pasted rows?

Hello thank you for your instructions, I did the exactly one with my workbook, question I need to do the same macro 5 times, copy and paste to different sheets, Is not working for the second one. What I'm doing wrong?

Thank you for your nice tutorial, very helpful

Hey the explanation is good, wanted to know, what would be the code if i need to copy a row based on duplicate values in a particular column.

By watching ur video i think acha din aa raha hai sir ji 😇😇😇😇

Hello Sir, Very nicely explained about the VBA Code & very easy to grab it, pls keep up the good work, we learn from you a lot.

great work ...thank you so much , it makes data visibility so easy

Thanks bro. Your vid is very useful for beginner like me!

It was surprisingly difficult to find anything else with this information here. This was very helpful to me for my little project at home. Thanks!

Is there a way to also make the button do sheet3,sheet4, and sheet5 for East,West, and South all at the same time?

I need small changes on this, how can I select requred columns on this code, please help me Ex out of 10 columns I need only 3 columns.

How do you get it to copy to second page just adding to the bottom row and not copying it all over again? Is it an offset, or +1 row code??? Much needed help.

Thank you very uch. Is very interesting. I have separate workbooks for different accounts being handled by me. The data there is having conditional formatting showing cells in red colour if the due date is past, in green if the due date was two days ago to days in future and yellow if it is mor than 2 days in future. These workbooks have multiple sheets with similar formatting. I want to have a dashboard of specific rows that contains even a single green cell. I also need to copy the name of the workbook in a column before the cells from other workbooks are copied. Please help me.

What would the code be if I wanted to paste value vs. "activate.paste"? The usual "PasteSpecial Paste:=xlPasteValues" keeps giving me an error.

Simple and perfect. Thanks

Hi do we have any macro which runs for entire column in excel

Dear Sir, Thanks for this very important video, However I need your help in the way that when i apply this formula, the data in other coloumns in the copied rows gets deleted, how can I just ensure that I copy only those coloumns where data is present in the Sheet 1 instead of all the coloumns Thanks

How can I have the IF statement copy based on a range of values? I need to select all lines that are within a text range.

I am encountering the same problem as Stephen O'Reilly below. " it's been a great help in getting me started but I need some additional help please? I want the data to be copied from a master sheet to a number of other sheets in the same workbook. The problem is that each time I click the button to copy the data it copies all the date over and over again. I would like it to only copy the latest line item to be added. Please can you give me some help on this?"

Hi Sir good day. I came up with an issue that I want to copy and paste the rows with certain criteria which is not readily stored in the column. Say I need to break down the start and end dates into individually respective months ie feb 4 to May 15 as feb 4 to feb 28 mar 1 to mar 31 apr 1 and apr 30 etc without affecting other columns and populate them onto another spreadsheet. How can I achieve this plz?

Is it possible to string together multiple command buttons into one? Also to stop it from copy pasting if it is a duplicate? Multiple command buttons say if I want to copy past from a master list to assign to a sales reps sheet, but I have multiple sales rep sheets.

Very nice tutorial..shore and simple..detailed..keep it up Sir..

Hi, how to delete the rows when finished copying ? please help. Thanks

Thank you so much for this video!!! Just in my case, I need to automatically generate different sheets for certain conditions, let's say in this case need to generate four sheets for East, West, South, North, can you tell me how to change the code? Or the only way is to make each condition a separate button?

Can I give two column conditions? If I have two columns stating North, for example you gave.

Is there a way to edit the code to avoid duplicating entries, in case you add new data to the main sheet and want to copy it to the other sheet without also recopying and pasting the old data that was already copied to the other sheet?

Great video, I have a sheet imported from another program where the columns change constantly depending on the data. I would like to look for a certain column header, and if it exists, copy that whole column to another sheet, can you think of a way to do this?

Thanks! Great video - useful and easy to follow steps. Is it possible to transfer only certain columns when "North" criteria is met? Or would you recommend I have a working-tab, whereby the data is pasted into it and then another macro removes the columns, before repeating the first process, albeit from a different sheet. Thanks in advance.

Hi, thanks for the video. Is there any way that I can apply the above code with the added condition of only copying and pasting over new rows? How can I modify your code to achieve that? Thanks.

Can you tell me please how to paste special row in which i wish to only paste value without formula.Please tell me?????

You are so great. Appreciate this very much. Sail on.

If we wants to do the same between two different workbooks rather than two worksheets in single workbook, can you please help. It would be a great help if you could help me here by providing code for this. Example: I have two workbook called workbook1 and workbook2. I want to copy rows if condition is met from workbook1 and paste it in workbook2. Thanks

Exactly what i was looking for sir. Thank you so much.

what if i want to just copy conlum b to another sheet from c12?

Sir I m following your channel since long. I have learnt a lot. Thank U . I have one question .. i want to update data if condition met i.e. ID, If ID Exists data should be updated but if ID doesn't exist the data should be save in last row of database. Kindly help.

hi sir, super concept, i have doubt, if any possible to copy specific rows based on emp id eg: i want copy the data emp id like 1002, 1005, 1008 to another sheet (not based on region, salary) using textbox or any other method..kindly reply sir...

when i select a data from drop down list on the sheet 1 at the same time the related data from sheet no 3 to be saved in sheet no2

Short and concise- plain English Keep up the good work.

Is there anyway to this exact action on a new workbook? I keep trying and for some reason it is only pasting one row. When i do it on a new worksheet it works completely fine. Anyone able to help me?

I am new to VBA and trying to do a similar code. basically, I want to search for an exact word in the column and then copy the rows to another worksheet. Is this something you can help me with, please?

You're awesome! Thank you for this.

THIS IS WHAT IWANT!! AMAZING 🥰🥰🥰

Always excellent. Do you have any advice on updating code when inserting adding and deleting columns? Is there a way to make the cell / range references dynamic in the code? Thank you

how to paste the range in rows eg:D1:J1, i am getting it pasted in columns eg D1:D10

Hi! Video is excellent and very helpful however, I have one doubt. I have multiple keywords and I have written multiple codes like the same code sheet. Now I want a line of code to be added in this code in such a way that after executing one code it should automatically add an entire row after the last filled row and then take next set of code and apply till last. I tried it many ways but I am not able to get it. Please help me out.

Thank you my man for simplifying this, you explained it a manner that totally makes it easy to understand. Bravo!

Hi Thanks for the video. Could you please help to demonstrate, how to create bar-code printing label(lay out) using excel. in my case, my table consist of Product name, Product ID, Price and Quantity that I need to print.

Thank you very much, heartfuly . It works!!!

Hi, does anyone know how can i copy cells instead of the entire row? I just need 3/4 cells in the row to be copied over. Also is there a way for me to start copying to the 10th row in another worksheet.

What if there are multiple tables in a sheet separated by texts. How can those tables (only tables) copied or cut and paste-special (without formatting) in another sheet?!

nice tutorial, can you please tell me how would you make it dynamic so it automatically copy rows without running macro again also how to avoid duplication, so copying the same rows again?I would appreciate your help

Nice tutorial, keep it up! ~^^~

THis Code is helpful for small data, in large database this code is time cansuming, can you suggest code for less time same purpose.

Very informative. Thanks for this.

Works like a charm :) Can you please, tell me how to delete the empty rows that are left behind? and how just to delete a row containing a specific word? Thx

Hi, very well explained. Could you please tell what needs to be done if we want to copy the row which met the condition and insert a new row below and paste it there?

Sir I want to know that if new data is added in sheet1 then whatever new data met condition that will be merge into another sheet ,,instead of the whole (including new data) data should be added into the sheet2...sir kindly tell me.

Thank you very well explained

Hi it was great , you made it simple & easy.... i would like to know how to move the updated data from the sheet 1 to sheet 2, i want to move only the the data added newly to sheet

Thank you :) it works good :D

Hello, folks! is there any way to compare cell value with multiple string values. in the following line. if Worksheets("RawData").Cells(i,3).Value = " Person1" Then

Hi Chetan, Great information. Thanks for this. I have a query that I have two sheets Sheet-1 with column A,B,C,D and sheet-2 with column A,B,C,D and whenever I am writing a name in Column A of sheet-1 then it should auto-populate the value in column C as it is available on Sheet-2. For Ex. If in sheet-2 the data is available like for column C,D as Name and Age, name = John has age = 10, name = Peter has age =12 . Then when I am going to write a name John in sheet-1 then it should auto-populate the age in column D. I want to write a macro for this. Can you please help with this? Thanks.

Thank you so much! It's a great one

When I press the Button, the Macro works fine, but as soon as I save the worksheet the Data changes, how can I stop it from doing that?

Thank u ,it’s so interest

i have something similar but instead of region i have codes in that and i want to move as per the codes in different sheets. I am not familiar with VBA Actually i am working on BOQ pages and with the help of the codes given besides the items want to transfer to different sheets (comparison) as per the codes (1-50). if you give me your e-mail i can send you the excel input and output what is required.

hello there , this is a very useful video , but one small thing , if u added new data to the original sheet , and then press command button , it takes all data specified even the already copied ones before , is there any formula to copy only the new rows entered

Can i use this code many times or not like 100 times over 100 sheets

1.000.0000.0000.0000 Thanks to You!! You solve my problem ;)

You are a lifesaver! Thank you so much for this.

I want VBA code for copy past data from sheet 1 to another sheet Condition is .. If column c have 0,00 and E column have bank value then I want to copy this to another sheet and delete this rows (clt - ) and column E 00 and column c for blank copy past in another sheet and again delete this rows

Great video. Thank you very much. I plan to use this at work next week to save tons of time.

If you push the button twice it just copies everything again. Is there a way to replace the data that's already been copied over to sheet2 or not copy data that's already been copied?