Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)

Подписаться 2,6 млн

Просмотров 609 тыс.

50% 1

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Learn how to automate tasks with this tutorial. Learn how to use the Excel macro recorder to copy or transfer data from one worksheet to the bottom of an existing data set on another sheet. You also learn the difference between absolute and relative macro recording.
⬇️ Download the workbook here: pages.xelplus.com/vba-copy-da...
📘 Key Concepts Covered:
▪️ Absolute vs. Relative Recording: Understand the difference and how to use them effectively.
▪️ Practical Example: Copy data from "NewData#1" and "Number 2" tabs into a "SummaryData" tab.
▪️ Finding the Next Row: Learn how to locate the next available row for data entry.
▪️ Developer Tab Insights: Discover how to toggle Relative Referencing on and off.
▪️ Visual Basic Editor: Watch real-time coding during macro recording.
This Excel VBA tutorial for beginners, is part of my "Unlock Excel VBA and Macros" course. Get access to the complete Excel VBA course here 👉 www.xelplus.com/course/excel-...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #vba

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

1 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 373

@LeilaGharani 4 месяца назад

Grab the file I used in the video from here 👉 pages.xelplus.com/vba-copy-data-file

@itisrahul1706 9 дней назад

This link doesn't work after I enter my details. Could you please check?

@Pankaj-Verma- 5 лет назад

You might not know but you are great at what you do. May your future be the Brightest. Thank you for bringing such incredible knowledge to us.

@wmfield152 4 года назад

I just ran across this video while searching for something else. It so happened that I needed to do this very thing in my current project. I don't believe I would have been imaginative enough to record absolute and relative in one procedure. Not only does it get the job done, it is simple and uncluttered. This was a big help. Thanks again L!

@rakeshkumarmadella7955 10 часов назад

Hi Leila, thank you for so much you are the best teacher we can ever have... I love this channel a lot... i learned many things from you channel and download the sheets and working on it every day.. God bless you abundence

@devika01dd 4 года назад

Hi Leila, I have seen a few of your videos. They are really useful and I absolutely love how you teach! You do a great job.

@MsThing81092 4 года назад

I have watched a lot of videos on excel formulas and vba macros, and you are by far the best at explaining these concepts and methods in a way that sticks. When I'm writing formulas or macros, I hear you in my head -- like when I'm writing an Index Match formula. Thank you for all of your wonderful videos! ♡

@LeilaGharani 4 года назад

Many thanks for the kind feedback. I'm glad you like the videos :)

@tahirshah6979 4 года назад

Thanks for showing that we can use both relative and absolute options in single recording. You are very intelligent.

@thomasguiavarch1506 2 года назад

You just gave me a solution of a problem I'm trining to solve from three entire days of research on forums and RU-vid videos. Many thanks 🙏

@fareedbadar8793 6 лет назад

As always, this time also you explained the subject in a simple and beautiful manner. It is very helpful for us. Thank you

@LeilaGharani 6 лет назад

I'm very happy to hear that. Thank you Fareed.

@pratikborkar 4 года назад

Haven't seen any best teacher than you, looking froward to watch all the vids on ur channel

@ckokse 6 лет назад

Wow, this is amazing! I am so looking forward to your complete course on VBA. Looks like I will be busy studying for a while 😍

@LeilaGharani 6 лет назад

Glad you like it! You should for sure put some time aside. But the good news is you have life-time access so you can go slowly but surely :)

@jeanroldson Год назад

This is a great explanation. This is what I needed. You explain the differences and logic of how they work.

@robvillegas216 9 месяцев назад

You rock Ms Excel. You save me a lot of time an effort and not to mention. just sent my work in. You're a Godsend

@miraskhabibulla1345 3 года назад

Leila Gharani, you are amazing! Many thanks to your effort and comprehensive explanation!

@excelisfun 6 лет назад

Thanks for the cool video about Relative and Absolute References in VBA !!!

@LeilaGharani 6 лет назад

You're very welcome teammate Mike :) I'll be switching to some VBA fun for a little bit....

@rockmetal377 5 лет назад

@@LeilaGharani you guys are frineds?.. Excells Fun is like my old teacher and now Leila is my university teacher.. Respect for both of you.

@tungnguyen363 2 года назад

Thank you SO MUCH! Your explanation was GOLD. You made it so easy to understand and it helped me with my work!

@bhupeshatpune 2 года назад

Hello Ms. Leila, you are one of the best teacher I have seen. Thanks lot for tutorials.

@engrasifalirazabhuttoya 4 года назад

Much informative! Useful. I’m looking forward to your Excel VBA course! many thanks

@ejikechime8864 5 лет назад

This is so nice, Leila you are just the best. I love the way you simply it, you are doing a great job please keep it up

@gouravkohli4573 3 года назад

Omg!! your voice is just harmony to my ears thanks for all these pro videos

@LeilaGharani 3 года назад

Wow, thank you!

@mahmoudbasheti3551 5 лет назад

Clarity Queen .. Thank you again

@dontbeafraid5313 4 года назад

You are the only lady teacher I am listening to right now. Easy to follow

@LeilaGharani 4 года назад

That's good to hear :)

@mihretabneway6811 4 года назад

Hey Leila, awesome tutorial and you explained it very neatly and in simpler ways.

@priyaa0512 6 лет назад

Really loved your narration n crisp clear explanation with calm tone.Great job!👍 Thanks for the new chapter

@LeilaGharani 6 лет назад

You're very welcome. Thank you for your comment. I'm glad you like the pace of the tutorial.

@narendrangananathar8107 3 года назад

Thank you Leila, great piece of work, thanks for sharing with us. It helped me immensely and I appreciate your efforts!

@Ssam33r121 2 месяца назад

I like her way of talking. I wish I could be like her. She explains in a way that I really like. Thanks Ma'am.

@mobr. 5 лет назад

Impeccably explained. Thank you.

@MohammadAshooryan 6 лет назад

you have a well way to teach excel and now vba too,with simple example and step by step, I learn from you for doing better in writing formula and now i'm trying to learn vba.with youre first lecture about know how and when turn on/off relative reference in recording macro.this is the good start to learn it, I see what happend when i do somthing.very very thank you.

@LeilaGharani 6 лет назад

I'm really happy to hear that Mohammad! Thank you for the very nice comment. Yes Macros are really powerful and actually quite easy to use. This week we'll see some more on macros. Thank you for the support.

@MIrshadIqbalRao 4 года назад

No doubt its a Great work, Till today I use the below technique to perform this job Range("A8").Select Selection.End(xlDown).Select a = ActiveCell.Column b = ActiveCell.Row Cells(b + 1, a).Select

@Rajan-kk8nl 5 лет назад

Lot of thank you medam, your teaching and explanation are very super. Wish you happy newer.

@theterracegardeningchannel5539 Год назад

Anytime i need a solution to any Excel Problem this is the place i find the perfect solution i need.. Thanks a ton :) :)

@olabodeolujomoye 2 года назад

Thank you Leila. Super awesome stuffs 👍🏾

@tsgtwright1437 6 лет назад

Outstanding Ms Gharani. I've learned so much from you over this past 18 months

@LeilaGharani 6 лет назад

I'm very happy to hear that. Thank you for your support over the past 18 months :)

@rosamaulini177 6 лет назад

Always clear and easy to follow. Really appreciate your videos. Thank you!

@LeilaGharani 6 лет назад

You're very welcome Rosa. Thank you for your comment and your support.

@1gopalakrishnarao 6 лет назад

Thank you Madam, long pending work just materialized, Your way of explaining the things is very beautiful, simple and memorable. Thanks a lot. Waiting very eagerly to learn some more tricks/tips/techniques. You are very lucky, many many followers are appreciating your great work and the love for Excel is growing everyday. BIG SALUTE

@LeilaGharani 6 лет назад

Thank you very much Gopala - Yes - finally macros and VBA :) I'm glad the love for Excel is growing every day. I appreciate your support and the support of all other followers.

@1gopalakrishnarao 6 лет назад

Thank you very much Madam

@andrewmoss6449 6 лет назад

Your new course looks really interesting. Can't wait to buy it!

@LeilaGharani 6 лет назад

Thanks Andrew :) It's been a lot of work and but also fun putting the course together. I'm looking forward to your feedback once it's out.

@blrdls 3 года назад

THANK YOU! I was not aware there was such a thing as Relative Recording until now.

@mtsplacement 5 лет назад

Thank you so much. Very informative

@kiasca3489 5 лет назад

You just save me time and struggle, clear as water. It's always great to learn new things, like I just have a revelation, THANKS!!!!. Is the course one time payment lifetime access? just making sure I understood right.

@franckchoserot9913 2 года назад

Great as always ! Thanks Leila, you are my bible !

@kadermeeran8816 4 года назад

Seriously You are Amazing in explaining in detail. Thank you for doing such a noble Job.I have seen many excel tutorial but your explanation worth watching and entertaining.

@LeilaGharani 4 года назад

I'm very happy to hear that the tutorial is helpful.

@rajkanojia1725 5 лет назад

Ma'am it's really well explained & helpful. Thanks a lot

@yetut2146 11 месяцев назад

I don't need it for now. I just love watching good stuff

@sarwansingh9423 3 года назад

You know everything to explain....in clarity...thanks again

@katiedeboer7725 5 лет назад

Thank you! This helped a ton!

@parmarboyz 5 лет назад

This is what I was looking for. Tried on many blogs but finally found it here.....Thank you!!!! Perfect Video.... :))

@LeilaGharani 5 лет назад

You are most welcome.

@georgekiwi8178 5 лет назад

Great video Leila! Thank you :)

@shardulshinde7309 4 года назад

Excellent Video.. Really made it simple to understand and work with macros.. keep up the good work.

@harrypriestley2105 Год назад

Extremely useful thank you!

@hamzawaheed47 4 года назад

Thank You very much Ms Leila!

@vksvishwa 3 года назад

Beautifully explained in a very simple and effective way. Thank you.

@LeilaGharani 3 года назад

You are welcome!

@CostasMoschopoulos 4 года назад

Hello! Thank you for the great lesson!Whatif I would like to copy / paste a column from specific cell text and all the way down? Thanks in advance!

@Softwaretrain 6 лет назад

Fantastic. Thanks for sharing. I knew this like some other training but i love your training . Thanks.

@LeilaGharani 6 лет назад

Thank you. Appreciate your support.

@fahadhassan3291 6 лет назад

Awesome Explanation. Many months before i started learning VBA Excel but couldn't successful because explanation of that man was not looked professional and he use just Inputbox and msgbox to show results of coding. Now you are teaching EXCEL VBA and i hope, i will learn perfectly and professionally. as i learned before INDEX, match, offset and their techniques to use. Thank You so much for great Explanations.

@LeilaGharani 6 лет назад

Thank you Fahad! I'm very glad to hear you find the explanations easy to follow. It took me a while to add VBA to my courses, because like you say, it's a difficult topic to teach. It took a lot of thinking in creating and defining the outline and flow of the course. I'll share what I can on RU-vid as well. Just now I posted a video regarding range references. If you're interested, check it out. Wish you all the best with your learning.

@fahadhassan3291 6 лет назад

Thank You so much for suggesting. Last night i saw all your 3 videos on VBA and also practiced. You cover many important things as for beginners. I didn't learn many month ago enough that you cover in one video. Keep it up. Great Work. Very Happy To Learn By You.

@MalinaC 6 лет назад

Thank you, Leila! It's incredibly important topic!

@LeilaGharani 6 лет назад

You're welcome Malina. Agree - you have great VBA videos yourself! I just need to learn some Polish.

@MalinaC 6 лет назад

Leila, thank you, it's nice to hear it, especially from you :). I'll try to add comments in English :)

@LeilaGharani 6 лет назад

That would be great!

@nattawut_chatwiriyacharoen 4 года назад

Thanks Leila. I like the way you explained techniques. It's easy to understand, and your method is cool.

@LeilaGharani 4 года назад

Glad you like it :)

@marcellokassa6975 6 лет назад

Thanks Leila for this awesome video... You just made it easy!

@LeilaGharani 6 лет назад

Glad you like it Marcel :)

@theenlightened1s 5 лет назад

Thank you.. You posted this video at the exactly the right time I needed this..

@LeilaGharani 5 лет назад

Perfect :) I'm glad this helped!

@konli Год назад

man I have trying to do this for years Thank You !!!!

@konli 10 дней назад

start learning power query , I use to download several spreadsheets about 35 each month and copy it to the spreadsheets by customer. it took me a lot of work to automate The process!! With macros and ChatGPT ! I have a macro that ask me what file to open and where to copy them and then ask me if I want to save the file and if I want to open a new one. Before power query I had a formula to take care of the variable of the size of the different sheets. Started on a new payroll proyects using power query and macros and its a lot more faster. Dont worry no more on the size of the worksheet, with the tables of power quey Thank You Leila !

@rakeem6672 4 года назад

You are amazing . I learned a lot

@utujecleopatra3450 Год назад

You saved me nothing beats the feeling of an assignment well done 😁😁

@catherinefrederick659 3 года назад

I have watched at least 6 videos trying to accomplish what you just taught. Thank you so much!

@LeilaGharani 3 года назад

You're very welcome, Catherine!

@alexrosen8762 6 лет назад

Great stuff. Thanks Leila!

@LeilaGharani 6 лет назад

Thanks Alex. You're very welcome.

@lugamele 5 лет назад

Thank you very much for your help! It was so easy once I saw your video! I was looking for a solution for 2 days and I found just what I needed with this video!

@LeilaGharani 5 лет назад

I'm glad it was helpful Luis!

@esbi1124 4 года назад

I've just used it. Really useful. Thanks again.

@LeilaGharani 4 года назад

Great to hear!

@inderjeetsaini7526 5 лет назад

Very nicely explained.

@krishnayangupta9011 4 года назад

Thank you :) Helped a lot

@astuteacerbic 4 года назад

Hey Leila. Thanks for sharing this awesome knowledge. Not only does it help me in my work but it seems i look forward to learning with you and every day I learn something new. You are also very pretty. Keep it up

@LeilaGharani 4 года назад

I'm glad to hear that :)

@robertakwasiadjei8223 6 лет назад

Thanks Leila, we hope for more. Stay Blessed.

@LeilaGharani 6 лет назад

You're welcome Robert. Thank you for your support. Yes more is coming : )

@ismailismaili0071 6 лет назад

thank you so much ms. Leila I think it's my chance to learn macros really appreciate your video

@LeilaGharani 6 лет назад

You're very welcome Ismail. Macros are a lot of fun. It gets more fun when we get to tweak the macros and adjust them to our needs...

@sarojsuwal9434 6 лет назад

Thank you so much. I would be looking forward for more videos on macro & VBA coding.

@LeilaGharani 6 лет назад

You're very welcome. Yes :) more coming this week...

@origami_canoe1952 2 года назад

Amazing!! thank you!

@mdivyakanth 3 года назад

excellent job done.. thank you

@osamsadsamir2848 7 месяцев назад

Damn, after one video i'm the best VBA user of my organization 😂 Can't imagine when i finish all your videos Thanks so much Great Teacher Leila

@LeilaGharani 7 месяцев назад

Haha, that's awesome! 😄 Glad the video was helpful. Keep learning!

@johnborg6005 6 лет назад

Amazing Leila. I am not much into Macro recording. I am more of a formula person thanks to Mike :) but this was very interesting and I will surely follow your coming videos to learn new staff, maybe I will learn some VBA from you. Thanks

@LeilaGharani 6 лет назад

You're very welcome John! I understand - I love formulas too. Macros are really great though for automating routine tasks. I'm curious what you think about the next videos...

@esbi1124 4 года назад

Hello, really good. Thanks a lot.

@mongise7en Год назад

Awesome! Although you missed to teach or show how to remove the range referencing to A1 for relative macro recording. And you are right, it still works.

@amitfore 4 года назад

The Most valuable Video for a Beginner who wants to learn how to run Macro in Excel. Thanks for the this awesome lecture.

@LeilaGharani 4 года назад

Glad you liked it

@drhf1214 5 лет назад

Wow thank you so much!

@ahmedeltayfy717 5 лет назад

So Coooooooooooooooooooooool .Unique Approach , thank you for kind Explain

@09shirish 6 лет назад

i'm learning excel from you. You are my Master to develop me. I learn so may ideas from you (its 40-50%), its better for me. How can I told you, their is no words to say ! I cannot speak and write good english, but from your tutorial i can something to write and speak english, i'm leaving in tribal area. So mam thanks a lot. Mam now a days from your tutorial i'm interested in basic VBA.

@LeilaGharani 6 лет назад

Thank you so much for your very nice message Shirish! I'm very happy to hear you find the tutorials useful. Thank you for watching and for your support.

@jaouadbelkhalfi1235 4 года назад

Excellents presentation and work. thank you !

@LeilaGharani 4 года назад

Glad you liked it!

@yog146 3 года назад

Thanks a lot ❤️❤️❤️ .. I was struggling with one error & didn't know how to find solution inspite of doing everything right. Seeing this video I realised my mistake.

@bollywoodviral5680 4 года назад

thanks, it works for me.

@Rajan-kk8nl 5 лет назад

Thank you lot of thanks medam.

@johnborg5419 2 года назад

Thanks Leila. Very Interesting!!! :) :)

@sabrinacheng3207 2 года назад

Hi Leila, this is really helpful! thank you! I do have a problem with blank data not copying across using this method. Is there alternative solution I can use? thanks

@Bijudevadas 4 года назад

Very useful tutorial. It will be further useful if could put another tutorial for how to copy data from summary sheet to different sheets based on some criteria using VBA

@Raining76 4 года назад

U r the best .. thank you for your time and effort in these trainings

@LeilaGharani 4 года назад

It's my pleasure

@JI9131 6 лет назад

excellent, with the advantage of absolute and relevant reference working together

@LeilaGharani 6 лет назад

Thank you Joe.

@aljhun24 Год назад

Hi Leila, thanks for this video. This really helped me a lot to understand how Macro works. I just have one question, what if we add new rows from NewData#1 and 2 will the macro will capture the new rows in SummaryData sheet? I’m trying to create a running file from different sheets and integrate it in one sheet

@akileshsharma2523 4 года назад

Hi Leila, I would like to thanks for this class. I really understood very easily.

@LeilaGharani 4 года назад

I'm glad to hear that :)

@inddon 5 лет назад

Thank you Leila for the video. You have demonstrated the concepts in a easy to understand way. I was looking for something similar. Do you have any videos made where you can copy & paste columns from one workbook worksheet to another workbook worksheet using VBA? Example: Workbook 1 - Source.xls worksheet - Data 1 Workbook 2 - Destination.xls Worksheet - Main Copy data from worksheet 'Data 1' column A to worksheet 'Main' column C The VBA code would be in workbook 2. The copy paste is done without opening workbook 1 Thanks again and appreciate your help

@1ammotivatedphl162 4 года назад

I just subscribe to your channel since Ive learned new macro today!

@LeilaGharani 4 года назад

That's great. Glad to have you here :)

@AhmadMohassebElroby 3 года назад

Can you tell me why I press on like button before I watch video!!! I’m still learning more from all videos, thank you so much.

@ProgramadorExcelVBA 4 года назад

show muito bom Leila Att, Programador Excel VBA

@mytrainerdan 7 месяцев назад

Hi Leila, your videos are super helpful. I have been able to accomplish this same task on my own but I am struggling to figure out how to make it work within a table with an empty data set. Any suggestions? Thank you!

@ehtachii8893 3 года назад

this is very helpful thank you

@LeilaGharani 3 года назад

You're very welcome!

@behzadnavabian4970 4 года назад

Hi Leila , Thank you for your great and awesome materials. i just wonder if you can help me out with getting access to Menu bar in Excel via VBA? i would like to check whether one particular Tab ( the custom tab i made) is there or not.