Тёмный

VBA Macros To Copy Data From One Workbook To Another (in Hindi) 

ExcelNsg
Подписаться 1,3 тыс.
Просмотров 19 тыс.
50% 1

Copy and paste is one of the most useful activity in Excel.
In this Video, you will learn 3 easiest and simple method to copy and paste data in Excel VBA.
Here we have two different files and we will copy data from one workbook to another.
When we copy data from any workbook and paste it to another, we need to refer the files with workbooks or worksheets.
So here in this video, we will use workbooks or worksheets codes in vba.
Other Useful Videos:-
VBA Macro to Copy Data and Paste Into Closed Workbook (In Hindi)
copy data from one workbook to another vba without opening
• VBA Macro to Copy Data...
If you want to copy data from multiple workbooks and paste it into the master workbook then please see the below video:-
How to copy data from multiple workbooks into master (VBA Automation)
• VBA Macro to Transfer ...
copy data from one workbook to another in vba
copy data from one workbook to another vba without opening
copy data from one workbook to another in specific worksheet vba
copy all data from one workbook to another vba
how to copy data from one workbook to another in vba
how to automatically transfer data from one workbook to another excel vba
copy and paste data from one workbook to another vba
copy data from one sheet to another in excel based on criteria vba
copy data from one sheet to another based on criteria vba
copy column data from one sheet to another in excel vba
excel vba copy data from one workbook to another without opening
excel vba copy data from one open workbook to another
excel vba copy data from one closed workbook to another
excel vba copy all data from one workbook to another
copy filtered data from one sheet to another vba
vba code for copying data from one workbook to another
how to copy data from one sheet to another in vba
how to import data from one workbook to another in excel vba
vba copy data from one sheet to another last row
vba copy large data from one workbook to another
vba macro copy data from one workbook to another
copy range of data from one workbook to another vba
copy paste data from one workbook to another vba
copy paste data from one sheet to another vba
copy data range from one workbook to another vba
copy data range from one sheet to another vba
copy data from one sheet to another workbook vba
vba to copy data from one workbook to another without opening
copy data from one workbook to another using vba
copy data from one sheet to another in excel using vba
transfer data from one workbook to another using vba
import data from one excel workbook to another using vba
excel copy data from one sheet to another automatically using vba
excel vba copy data from one open workbook to another using vba
how to copy specific data from one sheet to another in excel using vba
copy data validation from one workbook to another vba
copy data from one workbook to another workbook in vba

Опубликовано:

 

21 ноя 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 29   
@gurnambajwwa
@gurnambajwwa 6 месяцев назад
Macro codes made very simple to understand. Thanks very much. Subscribing.....
@excelnsg1588
@excelnsg1588 6 месяцев назад
Thanks for your support.
@poojadayal9283
@poojadayal9283 2 года назад
Soooo helpful, thank you so much.
@excelnsg1588
@excelnsg1588 2 года назад
Thanks for your valuable comment, your comments motivate me. Thanks.
@mdnazrulislam3713
@mdnazrulislam3713 2 года назад
Great bro
@excelnsg1588
@excelnsg1588 2 года назад
Thanks for your valuable comments. Please my another video, which will tell that how to copy the data and paste into a closed workbook. VBA Macro to Copy Data and Paste Into Closed Workbook (In Hindi) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uk3vOkTg08w.html My be you find this useful. Thanks again.
@tanujsabharwal6435
@tanujsabharwal6435 2 года назад
Too goood
@excelnsg1588
@excelnsg1588 2 года назад
Thanks for your valuable comment. Always got a motivation from it.
@chandrashekharprajapati9451
Hello Sir It's very helpful video. I have one query i need copy data using filter on data
@excelnsg1588
@excelnsg1588 Год назад
Please go through the below video link, i hope it help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZOAVT-LXRxE.html VBA MAcro to Copy Filtered Data to Another Worksheet Automatically Thanks
@fishfoot123
@fishfoot123 2 года назад
Thanks for the coding
@excelnsg1588
@excelnsg1588 2 года назад
Thanks for your valuable comment.
@fishfoot123
@fishfoot123 2 года назад
@@excelnsg1588 hi sir, where i can learn entire macro details in Bangalore... Could you please help me with contact number if possible.
@sanjanasangani6124
@sanjanasangani6124 2 года назад
Hi, great video! Extremely helpful and easy to understand. One doubt- what if I need to paste sheet1 of multiple workbooks into multiple sheets of a single workbook starting from B2 ? could you share a solution for the same, please.
@excelnsg1588
@excelnsg1588 2 года назад
Thank you for watching the video and suggesting what you need. Yes it is possible to create a macro for copy data from multiple sheet into another workbook. I will work on that definetely. Please watch the below videos also, you find a help. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H3GrSQhXZ_8.html VBA Macro to Dynamically Copy Data from One Workbook to Another (In Hindi) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uk3vOkTg08w.html VBA Macro to Copy Data and Paste Into Closed Workbook (In Hindi) Thanks
@dudeyme3331
@dudeyme3331 2 года назад
👍 Pls add scenario are matching like date are equal
@excelnsg1588
@excelnsg1588 2 года назад
Sure I will make it in future videos. Thanks
@satyasadhannag4004
@satyasadhannag4004 2 года назад
Sir, your video is extremely excellent, but please add that next paste will be at the end row where the first copy is completed. Please me the VBA code
@excelnsg1588
@excelnsg1588 2 года назад
Thanks for your comments Your comments is precious for me. That is called 'Dynamic copy and paste'. It requires last row, and definitely I will make a video soon on this. I Will send video link too. Please subscribe my channel. Thanks again
@excelnsg1588
@excelnsg1588 2 года назад
Please watch this VBA Macro video, as you have requested. I hope you will find it useful. Thanks ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H3GrSQhXZ_8.html VBA Macro to Copy Data From One Workbook to Another (In Hindi)
@bholanathjadhav6049
@bholanathjadhav6049 2 года назад
Hello Can you please help me in how do we get latest excel file from SharePoint folder using VBA
@excelnsg1588
@excelnsg1588 2 года назад
Hello, in this case, we will use the file path from SharePoint instead of our local hard disk. This time not but I will create a video for this topic in the coming days. Thank you for your valuable comment.
@djmenon21
@djmenon21 2 года назад
Superb Video. What if the if Data1 sheet the data keeps on increasing? and the range mentioned is A1:E13 what if the record keeps increasing? Will this macro work in that case? or will it dynamically take the last row and copy paste it?
@excelnsg1588
@excelnsg1588 2 года назад
Hello, First of all thanks for putting your comment here. Second you asked a wonder full question. Answer is this code will not copy and paste dynamically. But I have created a video as you are asking for. Please visit below the video link VBA Macro to Dynamically Copy Data from One Workbook to Another ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H3GrSQhXZ_8.html I hope you are asking for this and you will find this helpful. Please feel free to put your comments or suggestion. Thanks
@shhprg
@shhprg 2 года назад
what's the code if need selected columns in DataSet2?
@excelnsg1588
@excelnsg1588 2 года назад
Thanks for watching it, and please watch the video carefully, I hope you will find your answer here. Thanks
@excelnsg1588
@excelnsg1588 2 года назад
If you want to know that how to copy and past dynamically in Excel VBA then please watch the video below ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H3GrSQhXZ_8.html VBA Macro to Dynamically Copy Data from One Workbook to Another (In Hindi) Thanks
@user-ix9hb7je4lGaurav
@user-ix9hb7je4lGaurav 2 месяца назад
Sonu hai yeah ?
@excelnsg1588
@excelnsg1588 2 месяца назад
means, who Sonu?
Далее
Суши из арбуза?!
00:34
Просмотров 715 тыс.
Macro option in MS Excel in Hindi
0:59
Просмотров 175 тыс.
The Ultimate Guide to Copying Data using Excel VBA
31:05
VBA Copy Specific Column From Another Workbook
12:41
Просмотров 11 тыс.
VBA to BROWSE & COPY Data from SELECTED File in Excel
10:00
VBA Macro to Copy Data from Another Workbook in Excel
13:39