Transfer Specific Worksheet Range Data from one worksheet to another based on condition 

Thank you so much...! For sharing your videos. It help me so much to solve my problem.. I'm so happy that know your chanel...

What if I want two conditions that if name and mobile number matches then only pull data. Can it be done?

I am trying to use this for worksheets that have 25 columns. It is failing at the ActiveSheet.Paste command. Here is what I have ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range(Cells(erow, 1), Cells(erow, lastcolumn)). There are also several hundred rows in each spreadsheet, I am not sure if that is affecting is as well. How can I correct this? Is ActiveSheet.Paste not usable after so many columns?

Beautiful. Exactly what I was looking for. Very well explained and presented. The way you have walked us through the code makes it easy to imagine how building upon the looping will accommodate more sheets. I hope. Thank you very much! Update: confirming. More sheets are easy to add. Changing the number of required columns is not difficult. This is also quite easy to change from a range of columns to a single column by replacing ´Range’ with ´Cells’ Again, thank you. 10/10

I would like to thank you and to tell you your teaching are very good for novice persons like me that wants to learns.

Hello Sir, this is really great.. i just want a bit more help on this ..in this video the macro is used to copy and past a static range like B , C or D . i would like to know if we could get this done based on headers example in sheet1 phone is B and Sheet2 D so instead of D can the range be defined based on the header "phone" i am asking for this because the reports that i receive same headers but not in same order .. hope my question is understandable

Hi Dinesh, Can you help me with another scenario of Data transfer. My sheet1 is the invoice page which i use it for me to input relevant data and print out the invoice to my customer. I have another sheet i.e. sheet2 which is used for keeping a record of all the invoices that i have issued out to my customer. In the sheet1 (invoice page), It contends data such as Invoice No. , Customer Name, Total (excluding GST) , GST @ 6% and Total (including GST) which are important for me to keep a record in my sheet2 whenever i issue an invoice. I need to have a command button on the sheet1 (invoice page) for me to transfer those data from sheet1 to sheet2. Appreciate your kind assistance on this.

Thanks Sir, it's very helpful

Wow sir, you made my day ... This helps alot to my work Thanks.

How to transfer single row data from one sheet to another based on condiiton and input is taken fron input box. please help.Thank You

hi Dinesh. Can you share sample files for this tutorial. Thank you very much.

Sir can you please guide me to transfer data in other condition. I have a similar arguments but doesnt have any name written in sheet 2 if i have “jason” as name written in sheet 1 and entire row of that data shall paste to sheet 2 of that “jason” name . Can you write the code for that please

Create a Macro to Copy Auto Filtered Dataset to a New Excel Workbook

Thank you for your superb, brilliant and precise explanation, making it easy for me (non coder) to follow and use your example. your code worked great in one of the file for me BUT i got stuck with Column A (myname) which has some blank cells within the data set. Code gives an error @ myname = Sheets("sheet1").Cells(i, "A").Value. Please help to work around this, source can have blanks cells but code should continue to match further. Thanks in Advance

Sheets("Sheet2").Range(Cells(j, "D"), Cells(j, "H")).Select THIS IS MY PROBLEM ITS NOT TAKE THIS LINE CODE WHAT TO DO.....

Hi sir, Nice tutorial. One Question : If I wanna stop at ActiveSheet.Paste without the afterwards loop ( since I only have one vaule in myname comparison), how should I edit? Thx so much

Hi Bro, I need the help of writing macros with below conditions. I have to send email of pending order list to suppliers. The excel data having approx 350 rows and 10 columns. And approx 40 suppliers, each supplier have different data Range to be auto select based on supplier name. Email address to be auto pick which is maintained in sheet 2. Please help🙏

Sir, can pls explain I have query I.e., if two sheets are available in each sheet has many different columns. But in both the sheets first columns will be same . I need to combine the 2 sheets as per the first column. and remaining columns should come automatically based on first column. Can pls help sir

It is possible transfer a data Name column (Sheet1) and Name Column (Sheet2) is same but Name is not Srl Wise. Please its a urgent...

67 thousand plus views and only 117 likes seems pretty unfair, you deserve more.

Sir I have an invoice format and in that format i have invoice no. Date, customer name, addreas, contact no., state, gst no, items, hsn code, qty, unit, price, amount, cgst, sgst, igst, other charges and total amount columns How we can transfer and save the data of above columns in other sheet table, keeping in mind that in our invoice format we have 15 items and when we are transferring the data from invoice sheet to other sheet these 15 items should save also Pls help me to save this data as u explain in your video....thanks a lot

Hello sir ... Your video helped me a lot to transfer Matching data. I want transfer unmatched data from one worksheet to another based on condition. How it will be done?

would you plz share the same Excel file? I am getting erros with given code. Thanks

Sir, you are a gem. Many thanks. God bless.

Hello sir Can you please help me with the query where there are multiple different excel workbooks with different headers different trade lines how can we copy paste the data automatically in a excel file with standard format header

Can you help Ive watched over and over and just can't seem to get it Master list on sheet 1 and each column has 6 items (master list has many columns I don't need) that i want to transfer

Hello Mr. Dinesh. Every Month I need to copy a range of data (e.g. D4:D32). The column is based on the month so for 1-4-2018 it is D4:D32 and for 1-5-2018 it is E4:E32 and so on.... Then I need to paste this range into another workbook where also the column is based on the Month so e.g. 1-4-2018 is M4:M32 and 1-5-2018 is N4:N32 etc... The Months are from 1-4-2018 till 1-4-2021. So I need a code which can copy a range of data based on the Month and also past in another workbook again based on the same Month. So I first select a Month and then I want to run the code. Can you help me with this complex case please.?

مرسی

Hi sir can you please help me. I have multiple excel files, I need only file name and particular Cell value in that excels sheets. Can you please tell the solution please 🙏

Hi Sir, Can you help me with my database. Its actually the same problem here but in the different scenario. I did add you in fb and pm you also.. Thanks in advance. Ravi James

Hi Dinesh, can you help me with another scenario? I have a workbook (a) that logs a ticket when it comes in and updates to another central workbook (b) with this information. I'm then trying to go back to workbook (A) and input other field values about the outcome of the logged job, once this has finished I then need it to update the original Central workbook (b) with it's information. but to do this I need the VBA code to lookup job number and post code and then copy the information from workbook (a) into workbook (b). I really hope you can help me out with this request Thanks Phil

very good information.

Hi Mr.Dinesh,I did the same thing but I got error 9my master file is really big and I change the range I & j to CC & CN even if used the same range I & J gives me the same error which is out of range can you help pleasethanks

Hi,Can u help me to prepare a report from master sheet to different(report) workbook that contains different sheets in which each sheet specifies the conditionally filtered value from main sheet.Means main worksheet contains 3000 items and corresponding 40 parameters.I have to extract data such that conditionally filtered each coloumn and corresponding items are to be copied to anothersheet of (report)work book which contains 40 sheets,each sheet contains data of one conditionally filtered data of one coloumn of main workbook.The names of the (report ) workbook sheet may be the coloumn names of main workbook.

Hi Sir, how do I transfer data from one excel to another excel, please share it will be so helpful to me

What would I do if the columns were not consistent? As in, instead of being in column B and F, copying the data, and extracting it, is it possible to copy/extract data from a column that has a consisten label such as "Tools"?

thank you sir.... its very helpfull but i want to copy and paste data from a challan, receipt, memo or voucher based on students or customers id.

Hello Mr. Takyar , it was very helpful this vba code . lets suppose instead of name i have vendor code which is listed under column B and as you noticed i have more than one vendor code therefore how can do the same in this case because what i need to go to another vendor code . Thank you and best regards.

Hello Sir Your all videos are very useful. i have 1 query i am working on data validation i want use data validation font in marathi language.

sir,I am having a small labour work doing industries. In there we doing work in the labour hour based. 1.a,b,c. come in a day in different time we first one as first but the work not complete, b's work is 2nd work and I stat work a'swork. so the a's work first one hrs that is 10 to 11 and the work done in evening 3.30 to 6.00. I want to bill for the "a"by the hrs Base 1hrs ×150

I have a folder named Patient folder. In the folder excel files with different patient names. I need to transfer the name of the patient, in a specific cell, and totals on 12 sheets named each month of the year. The data is going to transfer to a master excel spreadsheet with one sheet. How can I do this?

how do you copy newly entered company names based on dates from a master sheet of a different closed workbook without opening the workbook

Sir can we transfer data from one excel file to anotherr excel file on the basis of cell valie

Hello! What if I just have one input in one workbook to use, and match it against a column of data in another workbook? After which, I copy specific cells from the 1st workbook and paste it in specific cells in the other workbook.

Thank you so much...! For sharing your videos. It help me so much to solve my problem.. I'm so happy that know your chanel...

Hi sir, how to copy two excel sheets and merge the data in consolidated sheet?

Nice vdo thank you so much

I am creating similar macro. VBA gives compile error : Sub or function not defined??

hello sir this video help me a lot i just want a favor that i want to make function instead of button that u have made in the end plz rpl me how to make function to call macro

Hi Sir, I need your help. I have a closed workbook in a network directory and I have written a code to open file. That workbook contains 7 worksheets and each worksheet has a different name. The worksheet name will always remain same ; however, there is possibility of Case(upper or lower). I want to create a macro which will open a closed workbook saved in a network directory, open it in background, crosscheck if the sheet exists and then copy data from columns from B6 to Q6 till last row. If any of the sheet doesn't exist, it should give a message box letting us know that "which" sheet is unavailable ; however, still copy data from remaining sheets. Pls help

Thumbs up to your great tutorial for beginners like me. It helped me so much in my work where i needed to get excel data to be better managed.

sir....sheet1 me B column or sheet2 me D column to match karenga data ke nahi..???

Very useful for working professionals.Thanks for knowledge sharing.

How if i ihave two condition and find the result with two condition?

Sir very nice teaching lots of thanks.

Excellent explanation in this video. What would change if data transfer from sheetX to sheetY depended on matching multiple criteria? Want to transfer data from sheetX to sheetY per these rules: 1) transfer data from SheetX row # column X only if a name is present in previous row column Z 2) data must copy to sheetY row-column that matches sheetX worksheet name (a date dd-mm-yy) 3) note: there is a maximum of twenty-eight scores to transfer 4) note: row 5 column X cell value belongs to name in row 4 column Z -- and so forth 5) note: all worksheets are in same Workbook 6) could ask user to input date that values will copy to in SheetY row instead of capturing worksheet name SheetX (this worksheet name is "dd-mm-yy" format) Column X Y Z row 4 Bakshi row 5 ..................... 88 . row 20 Patel row 21 ..................... 75 . row 36 Raju row 37 .................... 60 . SheetY (this worksheet name is "Roster") Column A B C D ... Z Patel Raju Kalita Bakshi ... row x dd-mm-yy _____ _____ ______ ... _____ ... row y dd-mm-yy _____ _____ ______ ... _____ ... row z dd-mm-yy _____ _____ ______ ... _____ ... .

Sir, What pdf should I read to understand the coding. Plz, send link.

Excellent Job.... Keep your Good work going.... Thanks....!!!!!!!

Dear sir, I found this interesting, a question, however, a row with Idnr and a row with date in how do I do that? I made something myself but it does not work out what I'm doing wrong Sub transfer() Dim i As Long, j As Long, lastrow1 As Long, lastrow2 As Long Dim PAAR As String lastrow1 = Sheets("WEDSTRIJD").Range("A1:A7" & Row.Cownt).End(wlUp).Rows For i = 2 To lastrow1 PAAR = Sheets("WEDSTRIJD").Range("A2:A7").Value Sheets("SCORE").Activate lastrow2 = Sheets("SCORE").Range("A1:a7" & Row.Cownt).End(wlUp).Rows For j = 2 To lastrow2 If Sheets("SCORE").Range("A1:A7").Value = WEDSTRIJD Then Sheets("WEDSTRIJD").Activate Sheets("WEDSTRIJD").Range ("B2"), Range("b7").Copy Sheets("SCORE").Activate Sheets("SCORE").Range ("B2"), Range("AF2").Select ActiveSCORE.Paste End If Next j Application.CutCopyMode = False Next i Sheets("WEDSTRIJD").Activate Sheets("WEDSTRIJD").Range("A1:A7").Select End Sub

Sir Will this work on different workbooks also will this fetch only additional(new data) that is entered in the master workbook

getting error: 'first i tried this 'lastrow1 = Sheets("sheet1").Range("A" & Rows.Count).End(xlUp).Row 'then i used this lastrow1 = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row getting error in both

Hi Dinesh. Thanks for putting this up its great. When I run this macro I get a "run time error 2004" Using F8 Debug it happens after the copying command and just at pasting. The problem line is "Sheets("Sheet2").Range(Cells(y, "C"), Cells(y, "F")).Select". This throws up the error.I have checked the syntax in the whole script and seems OK. Any assistance greatly appreciated.

Hello sir. I have a project plan (Sheet 1) and want to move tasks to another tab (Sheet 2), in the same worksheet, if the tasks are indicated as "Closed" or "Complete". Can this code be used to do this? What additional coding should be entered to remove the blank rows from Sheet 1? Thank you.

Thank u sooo much ...by referring this video I have completed 3 hours manual work in just 5 mins 🙏🙏🙏🙏

Dear Sir I have a worksheet that contains name of new joiners. Date Joined | Name | Date to be enrolled | Email Address | Set Reminder I have an if statement in the Set Reminder column that if "date to be enrolled' is equal to todays date, then to flag that cell in red and put the text "Send Reminder Email" in the Set Reminder column. Once all dates are identified I need to copy the email addresses from the Email Address field and add them to the To: field in a blank outlook email. I also need to send a copy of the email to myself Then in the body of the email I need to copy all the highlighted rows in excel and paste into outlook body. Could you please let me how to do this. I have the following code: Sub SendReminderMail() 'Start with the definition of the variables to be used 'Dim means Definition Dim OutLookApp As Object Dim OutLookMailItem As Object Dim iCounter As Integer Dim MailDest As String 'Create and launch the Outlook application and open new blank email Set OutLookApp = CreateObject("Outlook.Application") Set OutLookMailItem = OutLookApp.CreateItem(0) 'capture the email addresses from excel spreadsheet that has "send reminder mark" against them With OutLookMailItem MailDest = "" 'because we have text in email address we will use counta function and the email addresses are in column 4 For iCounter = 1 To WorksheetFunction.CountA(Columns(4)) If MailDest = "" And Cells(iCounter, 4).Offset(0, -1) = "send email" Then MailDest = Cells(iCounter, 4).Value 'the value next to the email address, which is on the left, if that is in the same row, but 1 column to the left, if that value is assigned "send email" 'if the mail destintation is not blank, insert a semi colon after the first address and then the code will add the remaining email addresses. Separate with semi colon. ElseIf MailDest "" And Cells(iCounter, 4).Offset(0, -1) = "send email" Then MailDest = MailDest & ";" & Cells(iCounter, 4).Value End If Next iCounter 'You will now add subject line, bbc , body of email..etc. .BCC = MailDest .Subject = "Pension Enrolment Notification.." .Body = "Reminder: Your enrolment into the company pension scheme is now due. Please ignore if you have already advised us if you do not wish to enrol." '.Display .Send End With Set OutLookMaiItem = Nothing Set OutLookApp = Nothing End Sub I can't work out how to copy the highlighted rows and paste into outlook. I also want each email to appear separately and I need to check before sending. your help is greatly appreciated. Thank you Sue

How can I do the exact same thing but move the data within different workbooks. Can you please help. Thanks

Can you assist me on my query please? I have list of Divisions in Sheet 1 name as Division3 to Division 38 in column A2:A39 Each division has a set of data to be pulled from each sheet from M104 to X104 of Division 3 to Division 38 So in a row has a required field area - here I need to Transfer Specific Worksheets Range Data from multiple worksheets to Sheet 1 based on Divisions and their type of sales.

Hi sir Could you please share video,how to consolidate multiple excel workbook data to master sheet workbook for daily transactions reporting.

this is good thanks, can you please help little bit more..! I need to copy multiple rows from sheet1 to sheet2, sheet3, sheet4 and sheet5 based on a cell value in range M column..? pls guide me with it ASAP. REPLY

can you do this for another workbook?

This is excellent, thank you very much. How does one loop though the entire dataset (all columns in sheet 1) looking for myname (strings)? Thank you.

Sir,Can you please help me a project? I want to extract data from different sheets in a workbook based on date. The data's are string and integers. Each sheet has 4 columns. These columns are same in all sheets. I want to extract those data's based on date in report sheet in same workbook.

Sir, your,s posted all videos are very useful and Thanks I need some doubts if it's any possible to upload excel data to excel tools as well as get PDF format? Kindly provide the video Thanks you sir

Nice tutorial, one comment though - the screen keeps scrolling out of view. Maybe next we can do it in a full window mode. Thank you.

Hi Sir, I have 21 worksheets in a single excel file and I need to copy a specific range of data from each sheet and paste it to other sheet for consolidation. It wwill be a great help if you can show us an example for that.

This is transferring data from one worksheet from another but what I need is to transfer from one workbook to another ? How do I do that ?

Hello, i need your help kind Sir. My problem is that i created code to that is creating 7 sheets however in original sheet there is lot of data with specific name i would like by clicking the button i can transfer data to specific list

Hello , Your tutorial was helpful. I want to extend this code and write if a particular row in my name between both the sheets doesnot matches it should show an error message.Can you help me with the code?

hiwhat if I have two sheets , and I want to bring only different data from sheet 2 to sheet1?

sir if we use DATE in place of NAME as a condition then the variable will be of which datatype

Hi I want to transfer data from sheet 1 to sheet 2 by clicking update i have the file i wrote the code correctly but i don't know why it doesn't working

Hi sir, I would like to ask on how to transfer data from rows to columns in other sheet with the same value and formula from sheet one and also based in conditions if Thanks!

Can this be done with a closed workbook? If so How?

Dear Dinesh, the macro is great. How can I identify if in sheet1 has to same name entries (with different details etc. phone number), and transfer it to sheet2 but each one in a new row?

Hello Sir, If we have to combine the excel files from different workbook to one workbook with same column name then how will we write vba code for that.

Hi there, this is super helpful so thank you! I do have a question though, if instead of the range that you have copied from B to F, what if we only want the last column and it changes from time to time? I know I should use last column somehow however it doesn't seem to work for me. Any help would be great..

thank you very much for your videos cuz there are useful and interesting but i ask you for help me about how i can transfer data from sheet to another between two dates please . i will thank you

give you the code!thanks admin!

Hello sir, I've one question. How can i remove the transferred data from the sheet? Thank for the video, informative😀

thank you my friend, helpfull and with correct code

Thank you Dinesh for this video it is a life saviour for my school project

Very helpful thank you Dinesh! :)

You da man! Saved me 3 days of work. Was done in 1h with this.

sir i want to create a type of report sheet, where i have 2 sheet one data entry sheet and other is reporting sheet. And i want to show selected range form a column.

how I can transfer from two workbook master data to another the same thing but different workbookthanksash

Hello,Quick question - instead of copying the activated sheet1 columns as a range ( columns B-F), how can I copy individual columns that are not in a direct range (For example - B, E, L, Q)? Thank you!

Amazing trick! this will help me a lot :)

Mr. Takyar, Thank you for this video. It is very helpful. One question, I have a duplicate value in MyName, though the information in each row is different. How can I pull in the next row after the first is found?

Nice work and nicely explained :-)

hi sir i would like to know if it is possible to copy the cells to another sheet if the value is yes