Here's the link where you can download the files I use in the video. Download the Excel file to follow along: www.excelcampus.com/vba/copy-paste-another-workbook/ If you're new to VBA then checkout my free upcoming webinar on The 7 Steps to Getting Started with Macros & VBA. Register here: www.excelcampus.com/yt-vba-webinar Lots of additional links and resources in the description above. Please leave a comment below with any questions or suggestions. Thanks!
WOW! This is exactly what I needed. It seems like you made this tutorial video for me. I just modified it to go through 12 Sheets (January through December) using a For/Next Loop to copy non-blank range then paste values in the next blank row after destination file/sheet is cleared once. Thank you, thank you, thank you.
Just found this today and it helped me a lot to try and automate manual copy and pastes of my teammates. Will be trying to put some of these in a button.
1a) 3:13 - Open/ Close source Workbook 2) 10:02 - Clear Existing Data in destination before Pasting 3a) 7:15 - Copy/Paste below Last Cell in destination Workbook. 3b) 10:36 - Alternate destination Workbook reference. 3c) 11:36 - Copy/Paste below Last Cell in destination Workbook if worksheet name is unknown.
Thank you very much for this high quality video. You are very detailed and clear in your explanations which helps tremendously. I've been manually copying and pasting data from 12 spreadsheets to a master spreadsheet monthly and am looking forward to automating it.
Is it possible to have a prompt appear to allow end user select the file from a file browser to copy from so it is not hardcoded in the macro like if they might be copying from a different file each time?
Hi John, Required to create multiple files/workbook with the help of 2 master data. Example in Master data file, created 2 seprate files with State and company wise seprate excel sheet/tab. With help of VBA need to create seprate files created in one specific folder with Company wise (also it should have one more tabe with state wise).
Hi Jon.. great video on various methods of copying and pasting between workbooks. Your sample code and presentation are clear and help me organize my thoughts and the steps to proceed to the solution. Thanks also for providing the sample workbooks to follow along.. very helpful. Thumbs up!
Thank you for your useful tutorials! I quickly earned "Wizard" status at my new job by writing a macro that copies in data from date stamped system generated files using Application.FileDialog to set workbook variable and your lastrow/range.copy videos.
Thanks A.J.! And congrats on wizard status. I love it! Sounds like you are able to help a lot of coworkers save time as well. Awesome! Have a good one. :-)
@@ClintSevilla Hello! Honestly since doing this I’ve learned to use the Power Query for data import. That would be worth your time learning. I’m think for this one I used the “Open file” dialogue box and set a range in the destination equal to the raw data. Wiseowl VBA tutorials were a great job off point.
Say I have multiple data sheets and I want to copy each of them into a separate output workbook. Is there a way to automate copying each one into a separate templated workbook and save them separately?
How to do this so, that I do not have the other workbook open but I want to add the location to a cell from where the VBA can look for that excel file and get data from there?
How do you hot key a macro without using the record feature? I always have to record first, then go in and use that sheet before I start coding. Will the mode be dependent on workbook? or can transfer the script over to another computer and have it run there with the same hotkey?
how can i add a dynamic source file or set a validataion queshtion while preessing the buttone that will show the filename and ask for a validation / cahnge filename of the fulename
Hi, Its really good video but i have one question. Actually, i want that user specify the worksheet through variable, is it possible. As in the video at 12:38, worksheet index changed manually or statically with 1 as workbook have only 1 worksheet. My query is that is this part can be replaced through variable. Code ask user to specify the worksheet number, which need to be copied and later on, call it by variable..
I meant to also say thank you… so THANK YOU!!! You seriously saved me about 3 days worth of work! Between your help and the KuTools add-on that I just got, I’m on fire now! Lol
Hi Jon, can you please advise a solution if a major wbk is open but DS worksheets in workbooks are closed? I've one major wbk, and multiple workbooks and each workbook has multiple DS worksheets. so, the process is: the major wbk is open. macro command goes through each row, by opening a closed workbook, open DS worksheet and then paste data from major wbk to DS worksheet, goes to row below open another DS worksheet paste data, save and close workbook. goes row below open another workbook et c. The Major wbk has a reference to workbooks and worksheets. thanks!
This has just saved me an hour or more of copy and paste from sheets !, is there a way that this could be used to copy from a range of sheets that all have the same name but different date - eg 11.04.22 do not use to 16.04.22 do not use ? I have a sheet with the date range that is calculated based on workdays and need to collate the data from the 5 sheets and needs to be run each Monday for the previous week I m thinking that the name section could be “* Do Not Use” but this would pull sheet data from more than needed
Hi how can we insert row with some data in same sheet Example I have make a table and I want to insert same table below it by clicking one button I hope you can answer me
Hi, thanks for the great video, I am copy pasting info to a file where I am unable to access some squares and a block message pops up, is there a way for the VBA to bypass this and continue running the code? Thanks!
Hi, Great video. I have a question, I have the similar scenario. I have a table with data and I need to clear the data before adding new data from other workbook, I am able to do, but, while deleting, it leaves one row and when we copy new data, it leaves the first row as blank. Not sure, how to solve this. If you could help me, it will be great. Thanks in advance.
I have data in sheet A to be copied and pasted in another closed workbook in a particular sheet in it.. I have used right macro with correct references .. It is not throwing any error for the macro when I run it but still data is not getting pasted not sure what's the issue can u pls help here
Great video. Is it possible to send the selected information to a defined sheet in the recieving workbook? For example, my original data was collected on a Monday (I can have a cell value equal to the day, as a reference), and I want to copy it to the "Monday" sheet in the new workbook. Then i will collect new data on the Tuesday, which i want to send to the "Tuesday" sheet. Ultimately, the new data will have a reference, this will be transferred to the new workbook in the sheet labelled with the same reference.
Hi Jon. I have a task in which i want to take input from user the column digit and then i have to copy that column cell range to a new file which i will save as .xlsx on shared drive. Could you please guide me through how will i achieve this?
Hello, very helpful video. I get data in raw format I have to prepare that raw data in a particular format. How to copy data in row A and get the same pasted in row B using VBA.
Hi John.. Need a small help where i need to change the code to do paste special instead of just pasting the values.. could you be able to help on that pls?
Hi Jon , Is there a way to insert an existing excel template using VBA code.for example i have a excel template already i have written query for some work after that I need to use the existing excel template in the same macro..
Hi Jon, how about copy and paste a workbook with a VBA. Will it work? I ask you this questions because I noticed there are duplicates Alt + F11 at the right in the VBAProject properties.
Hi Jon and everyone. towards the end of the video 12:30 you stated that you could change the worksheet from the worksheet name to the number. is there any way that you can do that for a workbook that has a different name each time?Basically we are moving all of our old information from the old rater to our new raters and I'm hoping there is a way I can create a macro that will be able to transfer the information form any requested(open) workbook to our new one.
Hi, how will I delete data from the New data sheet. Such that when I run macros and the data gets transferred from the new data workbook to reports work book, I want that the data which has been transferred from New data it should be deleted too.
would you please reply, when I wrote this code I received a message sub or function that is not defined. please let me know how I can resolve this bug or error.
Do you have any tutorials that show this, but using a filepath that the workbook "report" changes week over week? So for example, I want to run a macro that imports data into a specific workbook, but the data source file is updated on a weekly basis and is saved with a different name: source_data_05_23, source_data_05_30 etc
How would you copy data from a read only workbook and sheet when it is a read only that is downloaded as a csv file, then when you download again it appends filename (#). Sometimes the filename is fine sometimes it adds. ie filename filename (1) filename (2) etc... I just want to copy the data from the original or the latest download (#)
What should we use in macro if we want to copy a set of data from multiple workbooks. Here in Eg. we have "new data.xls" , how about if i have to copy from another 100 workbooks to report.xlsm
Great vid! I need to copy and paste info from 4 worksheets inside a workbook to MULTIPLE workbooks that are basically identical to the one I'm using to copy the info from, I just need to update some formulas. The problem is, I need to do this with 300+ workbooks, is it possible to bulk copy and paste all this info to the specific range I need in an automated way ? I was doing it manually, but it's taking forever, and I need this done ASAP for work, can someone help me out ? thnxxx
Hi Jon or anyone, not sure why the first line works perfectly but when i put the file in a network folder and reference it like on the second line it gives an error 9. Set wsCopy = Workbooks("New-Data.xlsx").Worksheets("Export 2") Set wsCopy = Workbooks("\\NetworkFolder\New-Data.xlsx").Worksheets("Export 2")
@@barryc7443Hi! If you have the file already open, remove the reference to the network folder, leave the file name only Set wsCopy = Workbooks("New-Data.xlsx").Worksheets("Export 2") If you want the file to open when you run the macro, use the macro Jon has in the file to do just that! Hope it works, it did for me! Regards
Thanks, just what I wanted. Just a small question, the source file from where I copy keeps on changing, is there a way to make that dynamic, so whenever it changes, the same changes in the code? I am using getopenfilename to get latest file name, but I can't figure out how to incorporate the same in the macro.
hello, thank you for the help! just a question if the data being copied has a cell format the copy paste of last row is copying also the cells that are formatted and add the new data below empty cell with values and the formatted empty cell. how do just get rid of those empty cells without values but was formatted.?
Hey, The code runs smoothly but I just want to copy columns A and AE.. What changes do I have to make in the code line wsCopy.Range("A2:D" & lCopyLastRow).Copy _ wsDest.Range("A" & lDestLastRow) Please suggest.
Everytime I have to enter the data in a different sheet, I have close to 30 destination sheets, (source excel will be one for sure) where I have to copy the data. I cannot hard code the filename in macros, please help me with a solution where I can pass the destination filename and the macros will pick it up in the runtime
Useful and wel explained, thanks for making this available for the community. I have an issue using .PasteSpecial Paste:=xlPasteValues then .PasteSpecial Paste:=xlPasteFormats, I have a workbook where I need to copy a range "C4:C470" from current workbook to a new one.The range has conditional cell coloring rules (R then rd, b then blue.....) VBA does the job but when I visit the new file, already in windows I get "preview not possible, opening the file, I get "We found a problem do you want to repair, Yes then get "Removed feature conditional formatting....." then file opens with values but not the formatting. Have you come across this type of issue? Thanks for your help
Thank you... I have a question. I am trying to copy data from one workbook to another through opendialog method. Does anyone has any direction on how to do this?
Hi! That is a great video, thank you so much for making it! In my case the name of the workbook I copy the data from changes, is there a way to deal with that?
Thanks for the nice video. This is useful. May I check how to copy only new rows [there maybe more than 1 new row] from source excel, if only those rows are not found in the destination excel file and matches criteria [eg. West region]? Thank you Merry Christmas and happy New year
Thank you for the information. However I do have slightly different scenario. I do have 1 Excel file for each day of the month with different names in a folder. I do have to create a master file by copying certain cells from these files. Master file has to have 12 months data from 365 daily Excel files to create a year report. Could you show me a way. I am a novice in VBA and I may not able to edit your code to fulfil what I need.
Here's the link where you can download the files I use in the video. Download the Excel file to follow along: www.excelcampus.com/vba/copy-paste-another-workbook/
If you're new to VBA then checkout my free upcoming webinar on The 7 Steps to Getting Started with Macros & VBA. Register here: www.excelcampus.com/yt-vba-webinar
Lots of additional links and resources in the description above. Please leave a comment below with any questions or suggestions. Thanks!
I think you just saved my internship!!
word bro LOL
same hah
same hah
WOW! This is exactly what I needed. It seems like you made this tutorial video for me.
I just modified it to go through 12 Sheets (January through December) using a For/Next Loop to copy non-blank range then paste values in the next blank row after destination file/sheet is cleared once.
Thank you, thank you, thank you.
Just found this today and it helped me a lot to try and automate manual copy and pastes of my teammates. Will be trying to put some of these in a button.
Thank you Jon! You've just helped me to become a successful man!
1a) 3:13 - Open/ Close source Workbook
2) 10:02 - Clear Existing Data in destination before Pasting
3a) 7:15 - Copy/Paste below Last Cell in destination Workbook.
3b) 10:36 - Alternate destination Workbook reference.
3c) 11:36 - Copy/Paste below Last Cell in destination Workbook if worksheet name is unknown.
This tutorial shows exactly what I'm trying to achieve with an Excel project I've started recently...Brilliant ! ;-)
I am so happy with the content of this tutorial, thank you very much Excel Campus !
Thank you very much for this high quality video. You are very detailed and clear in your explanations which helps tremendously. I've been manually copying and pasting data from 12 spreadsheets to a master spreadsheet monthly and am looking forward to automating it.
I'm working on a project and cam across this video, what you've done will help so many! Thanks so much Jon awesome video Great job Sir!
thank you very much as a newbie at VBA it captured my mind and I got passionate about thank you for your videos
Happy to hear that! 😀
Great job, saved me a lot of time! God bless you
This helped me so much at work. Thank you!
hmm... DUde, what to say this was actually some instructive information! Thank you for explaining the basics!!!!! ❤👍
Is it possible to have a prompt appear to allow end user select the file from a file browser to copy from so it is not hardcoded in the macro like if they might be copying from a different file each time?
Thanks Jon. Very comprehensive
Very useful & I've incorporated this into my latest video where I've created an awesome tool for the average side-hustler. Thank you!!!
it's fantastic dude
thanks you, thanks a lot
greeting from Istanbul
Hi John, Required to create multiple files/workbook with the help of 2 master data. Example in Master data file, created 2 seprate files with State and company wise seprate excel sheet/tab. With help of VBA need to create seprate files created in one specific folder with Company wise (also it should have one more tabe with state wise).
So comprehensive, so successful
Learn VBA with Jon
Thank you bro, thanks a lot!!!!!!
Great video and easy to understand 🙏🙏
Thank you. You make my life easy to live.
Very helpful, thank you!
Thank you so much. This is very helpful
Thank you for your good work
So excited to use this!! :)
Hi Jon.. great video on various methods of copying and pasting between workbooks. Your sample code and presentation are clear and help me organize my thoughts and the steps to proceed to the solution. Thanks also for providing the sample workbooks to follow along.. very helpful. Thumbs up!
Thank you for your useful tutorials! I quickly earned "Wizard" status at my new job by writing a macro that copies in data from date stamped system generated files using Application.FileDialog to set workbook variable and your lastrow/range.copy videos.
Thanks A.J.! And congrats on wizard status. I love it! Sounds like you are able to help a lot of coworkers save time as well. Awesome! Have a good one. :-)
I am trying to figure out how to do that. Any references to point me to?
@@ClintSevilla Hello! Honestly since doing this I’ve learned to use the Power Query for data import. That would be worth your time learning.
I’m think for this one I used the “Open file” dialogue box and set a range in the destination equal to the raw data.
Wiseowl VBA tutorials were a great job off point.
Thanks you so much for the macro..it helped me so much
Say I have multiple data sheets and I want to copy each of them into a separate output workbook. Is there a way to automate copying each one into a separate templated workbook and save them separately?
THANK YOU VERY VERY MUCH FOR YOUR PERFECT HELP
How to do this so, that I do not have the other workbook open but I want to add the location to a cell from where the VBA can look for that excel file and get data from there?
How do you hot key a macro without using the record feature? I always have to record first, then go in and use that sheet before I start coding. Will the mode be dependent on workbook? or can transfer the script over to another computer and have it run there with the same hotkey?
Hi sir
Copy/paste below last cell in destination workbook can we create for different sheets data for this copy paste below last cell
how can i add a dynamic source file or set a validataion queshtion while preessing the buttone that will show the filename and ask for a validation / cahnge filename of the fulename
Hi, Its really good video but i have one question. Actually, i want that user specify the worksheet through variable, is it possible. As in the video at 12:38, worksheet index changed manually or statically with 1 as workbook have only 1 worksheet. My query is that is this part can be replaced through variable. Code ask user to specify the worksheet number, which need to be copied and later on, call it by variable..
Thanks! This is helpful. May I know if you have tutorial that will show how to copy only filtered data? Not all data
Great tutorial
can we create a loop to do this on a folder? I just have about 14 excel files that are identical in a folder that need to be put into one file
Can we do the same copy without openning the copied sheet?
Jon, you’re my new best friend!
I meant to also say thank you… so THANK YOU!!! You seriously saved me about 3 days worth of work! Between your help and the KuTools add-on that I just got, I’m on fire now! Lol
Thanks to Excel Campus!
Hi Jon,
can you please advise a solution if a major wbk is open but DS worksheets in workbooks are closed?
I've one major wbk, and multiple workbooks and each workbook has multiple DS worksheets. so, the process is: the major wbk is open. macro command goes through each row, by opening a closed workbook, open DS worksheet and then paste data from major wbk to DS worksheet, goes to row below open another DS worksheet paste data, save and close workbook. goes row below open another workbook et c. The Major wbk has a reference to workbooks and worksheets.
thanks!
Instead of pasting below the last row cell, what should I change for pasting right next to the last column cell?
Hello! is there a way to copy paste the selected cell only in another workbook?
How do we bind values in column wise, ? Like find empty column and paste the value..
Is there way to activate other Workbook and File End name is not foxed due to date and we can enter starting file name in vba to refer
can it be done with a command button rather than the F keys
This has just saved me an hour or more of copy and paste from sheets !, is there a way that this could be used to copy from a range of sheets that all have the same name but different date - eg 11.04.22 do not use to 16.04.22 do not use ? I have a sheet with the date range that is calculated based on workdays and need to collate the data from the 5 sheets and needs to be run each Monday for the previous week I m thinking that the name section could be “* Do Not Use” but this would pull sheet data from more than needed
I am adding paste special in 'set wsdest' line but its showing error of expected end line statement ...can u plz guide me how to paste special
Hi how can we insert row with some data in same sheet
Example
I have make a table and I want to insert same table below it by clicking one button
I hope you can answer me
Hi, thanks for the great video, I am copy pasting info to a file where I am unable to access some squares and a block message pops up, is there a way for the VBA to bypass this and continue running the code? Thanks!
Hi, Great video. I have a question, I have the similar scenario. I have a table with data and I need to clear the data before adding new data from other workbook, I am able to do, but, while deleting, it leaves one row and when we copy new data, it leaves the first row as blank. Not sure, how to solve this. If you could help me, it will be great. Thanks in advance.
Hey Jon - would you have the knowledge on how to pull data from multiple xlsm's that have merged cells and dropdowns into a master workbook using vba?
I have data in sheet A to be copied and pasted in another closed workbook in a particular sheet in it.. I have used right macro with correct references .. It is not throwing any error for the macro when I run it but still data is not getting pasted not sure what's the issue can u pls help here
hi, the video is good but I have a question. what can you do if the workbook that you are copying from changes the name or the file format? thankyou
Excellent contents, Thank you!
Great video.
Is it possible to send the selected information to a defined sheet in the recieving workbook?
For example, my original data was collected on a Monday (I can have a cell value equal to the day, as a reference), and I want to copy it to the "Monday" sheet in the new workbook. Then i will collect new data on the Tuesday, which i want to send to the "Tuesday" sheet.
Ultimately, the new data will have a reference, this will be transferred to the new workbook in the sheet labelled with the same reference.
Hi Jon. I have a task in which i want to take input from user the column digit and then i have to copy that column cell range to a new file which i will save as .xlsx on shared drive. Could you please guide me through how will i achieve this?
Hello, very helpful video. I get data in raw format I have to prepare that raw data in a particular format. How to copy data in row A and get the same pasted in row B using VBA.
Hi John.. Need a small help where i need to change the code to do paste special instead of just pasting the values.. could you be able to help on that pls?
I need to paste data in a staggered way (so not all in one block). Is this possible?
Hi Jon ,
Is there a way to insert an existing excel template using VBA code.for example i have a excel template already i have written query for some work after that I need to use the existing excel template in the same macro..
Hi Jon, how about copy and paste a workbook with a VBA. Will it work? I ask you this questions because I noticed there are duplicates Alt + F11 at the right in the VBAProject properties.
if I want to paste just some columns from another workbook, how I can do that? woth VBA
Thanks a lot. You made it look so easy.
Glad it helped 😀
Hi Jon and everyone. towards the end of the video 12:30 you stated that you could change the worksheet from the worksheet name to the number. is there any way that you can do that for a workbook that has a different name each time?Basically we are moving all of our old information from the old rater to our new raters and I'm hoping there is a way I can create a macro that will be able to transfer the information form any requested(open) workbook to our new one.
Hi, how will I delete data from the New data sheet. Such that when I run macros and the data gets transferred from the new data workbook to reports work book, I want that the data which has been transferred from New data it should be deleted too.
Dude, this lesson is soooo awesome, it's exactly what I needed ! thanks a lot, and there we go a new Like and a new subscriber ;)
Thanks for the video, just want to ask how about a vba for different workbooks name?
would you please reply, when I wrote this code I received a message sub or function that is not defined. please let me know how I can resolve this bug or error.
Why i cannot run the very first copy (open thype) it keeps say "the object doesn't support this property"
Can you please help me with the coding that how to MOVE and COPY the whole spreadsheet to a separate excel file
Do you have any tutorials that show this, but using a filepath that the workbook "report" changes week over week? So for example, I want to run a macro that imports data into a specific workbook, but the data source file is updated on a weekly basis and is saved with a different name: source_data_05_23, source_data_05_30 etc
How do I copy specific person data from one worksheet to another worksheet??? Also with varying range.
How would you copy data from a read only workbook and sheet when it is a read only that is downloaded as a csv file, then when you download again it appends filename (#). Sometimes the filename is fine sometimes it adds.
ie
filename
filename (1)
filename (2)
etc... I just want to copy the data from the original or the latest download (#)
Brilliant ! Thank you so much
What should we use in macro if we want to copy a set of data from multiple workbooks. Here in Eg. we have "new data.xls" , how about if i have to copy from another 100 workbooks to report.xlsm
simply excellent !!!
Great vid! I need to copy and paste info from 4 worksheets inside a workbook to MULTIPLE workbooks that are basically identical to the one I'm using to copy the info from, I just need to update some formulas. The problem is, I need to do this with 300+ workbooks, is it possible to bulk copy and paste all this info to the specific range I need in an automated way ? I was doing it manually, but it's taking forever, and I need this done ASAP for work, can someone help me out ? thnxxx
Hi Jon or anyone, not sure why the first line works perfectly but when i put the file in a network folder and reference it like on the second line it gives an error 9.
Set wsCopy = Workbooks("New-Data.xlsx").Worksheets("Export 2")
Set wsCopy = Workbooks("\\NetworkFolder\New-Data.xlsx").Worksheets("Export 2")
Does anyone know how to solve my issue , many thanks
@@barryc7443Hi!
If you have the file already open, remove the reference to the network folder, leave the file name only
Set wsCopy = Workbooks("New-Data.xlsx").Worksheets("Export 2")
If you want the file to open when you run the macro, use the macro Jon has in the file to do just that!
Hope it works, it did for me!
Regards
How to apply same concept when workbooks are store on MS Teams?
Really, very good.
Thanks, just what I wanted. Just a small question, the source file from where I copy keeps on changing, is there a way to make that dynamic, so whenever it changes, the same changes in the code? I am using getopenfilename to get latest file name, but I can't figure out how to incorporate the same in the macro.
hello, thank you for the help!
just a question if the data being copied has a cell format the copy paste of last row is copying also the cells that are formatted and add the new data below empty cell with values and the formatted empty cell. how do just get rid of those empty cells without values but was formatted.?
Hey, The code runs smoothly but I just want to copy columns A and AE.. What changes do I have to make in the code line wsCopy.Range("A2:D" & lCopyLastRow).Copy _
wsDest.Range("A" & lDestLastRow)
Please suggest.
Thank you Mister
Great Video! How would you copy and paste above an existing range?
Everytime I have to enter the data in a different sheet, I have close to 30 destination sheets, (source excel will be one for sure) where I have to copy the data. I cannot hard code the filename in macros, please help me with a solution where I can pass the destination filename and the macros will pick it up in the runtime
Useful and wel explained, thanks for making this available for the community. I have an issue using .PasteSpecial Paste:=xlPasteValues then .PasteSpecial Paste:=xlPasteFormats, I have a workbook where I need to copy a range "C4:C470" from current workbook to a new one.The range has conditional cell coloring rules (R then rd, b then blue.....) VBA does the job but when I visit the new file, already in windows I get "preview not possible, opening the file, I get "We found a problem do you want to repair, Yes then get "Removed feature conditional formatting....." then file opens with values but not the formatting. Have you come across this type of issue? Thanks for your help
Thank you... I have a question. I am trying to copy data from one workbook to another through opendialog method. Does anyone has any direction on how to do this?
Hi Jon.Thank you for this video. It saved me a lot of work.. How can I copy the data from the other sheet while keeping the same format?
i have some images in my sheet which are not getting copied and also the text box text size gets bigger when i copy it to the current sheet
Hi! That is a great video, thank you so much for making it! In my case the name of the workbook I copy the data from changes, is there a way to deal with that?
Did u get it
Thanks for the nice video. This is useful. May I check how to copy only new rows [there maybe more than 1 new row] from source excel, if only those rows are not found in the destination excel file and matches criteria [eg. West region]?
Thank you
Merry Christmas and happy New year
Hi, this is very helpful. thank you. Just one question, when pasting the data where would you include paste special to just paste values.
thanks
Hpw can we add row data one by one using for loop ?
I have a template and every week I need to copy the data whose status is open to next week sheet. is there any way this can be done? Thanks
Thank you for the information. However I do have slightly different scenario. I do have 1 Excel file for each day of the month with different names in a folder. I do have to create a master file by copying certain cells from these files. Master file has to have 12 months data from 365 daily Excel files to create a year report. Could you show me a way. I am a novice in VBA and I may not able to edit your code to fulfil what I need.
10:35
Thanks Jon for the helpful tips. Putting it to work right away :)
Awesome! Thanks Rachad!
How can we copy a range of data if both the rows and column are varying..