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

Great video as always - but did i miss the section on how to create a JPEG or GIFF file from the barcode created?

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

Thank You!

Under offset syntax. Why does it takes range a1. Select? What's the reference of range a1
Select. Cant we only do active cell. Offset(1,0). That's it?

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

Hi Leila. Can you advise all the Vedio here is same as the one in udemy? Was try to sign in to that.

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

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.

Hi i want to is there any option that we can disable the complete sheet from manual printing only if we click on the button/shape it will print ?

Je t'adore 💜

Can you please suggest an easy way for me to make a macro that places the Excel cursor or focus on the first cell (column A) in the next free row? Thank you so much.

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

When i copy hyperlink to othersheet then, hyperlink is not working in other sheet
Please tell what would be code???

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

Hi Leila, first of all - thank you for your great content!
I hope you are able to help me with my question as I was not able to find an answer yet...

Let's say I have created a table and a form and a button that will enter a new row to it with a data I have entered in the form.

The only option I could find on line was to add it as a last row.
Is it possible to enter it somewhere at the middle? Let's say I want to select (in the form) the location of the new row in the table. Is that possible?

And one last question -
If my table is placed above a different table or some row that is not related to it - is it possible to push the row doen to add additional rows to the table through forms?

Hope my questions are clear and thanks again fir the great content!

Extremely useful thank you!

I think it doesn't work when there is nu data yet. What can you do when list is empty and you want to start copieing?

Hi Leila.. I recently heard Microsoft is planning to block Visual Basic for Applications (VBA) macros by default in a variety of Office apps. But soon after they re-enabled the default Office VBA Macros after strong opposition and feedback. So, is this course worth learning? Please advice.

Thank you for your nice lessons. I have one problem applying the steps, pressing Enter key pastes the copied cell's content. Is there anyway I can avoid that?

Thank you so much, I have question please, my data contains a lot of zipcodes. I want do analyze them in different aspects such as population, income and so on and the step like following
1- find the nearest zip values and compare them to the primary zipcode and then rank the primary code.
2- keep the primary zipcode along with nearest zipcode. So when I search for primary zipcode the nearest code should appear too.

Can you please advise me what type of formula I use? And on how to group primary zipcode with nearest zipcode?

Thank you again for your very useful videos

How to copy just one row to a tab based on a selected drop down menu?

How do i loop through all tabs and copy from all of them instead of clicking, since sometimes we dont know how many sheets are there

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

So I have just had this job and I produce Same report every week. I am curious to know how I can fit in macros from copy pasting from the accounting software xero into excel. If there is any course you have I am happy to sign up as this will help save loads of time. I have tried recording macros however, it does not work, when I come to produce the reports.

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

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

Hey Leila, Thanks! Do you have a video to select selective columns from one worksheet to another in same excel? or this video should be enough?

Hi Leila, I am not sure if you have this if some of your previous videos, maybe you could point me to it? I am fetching data from Web in one tab getting live cryptocurrencies prices. Now I have another tab where I am having my portfolio for every cryptocurrency I own. How can I link price from first tab to this one to automatically updated for desired crypto? My problem is that in first tab cryptocurrencies changing their order every time when updated. Thanks a lot in advance!

Thank you Leila. Super awesome stuffs 👍🏾

Hi. Amazing.

I'm confused

i have seen many videos of your its which have help me save lot of time , now if we have lots of data and transfering that data partywise to another sheet but if that data is more then 1 page i want to show that data head to all the other pages also

My query is as follows can you help or guide me?

I have an Master excel sheet with 10000 records where 1st a set of filters are selected and data is copy pasted in sheet A say 5000 with headers. Then 2nd set of filters are selected in the Master Excel sheet and appended in sheet A (no headers as its already there from the first copy paste). How can we create a macro for that?

Is there anyway to add Macro for the sheets will be added in future? For example monthly sheets done until August but will be added until December later o

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

Hell mam VBA programming learn basic to advanced .

Kindly upload video for VBA to handle pivot tables when the filtered data doesn't exit...

Hi, I have taken a few of your Udemy course and still can resolve me problem below. Can you help?
Fill or flash fill formulas left to right ( using microsoft365)
Two sheet workbook. I have an Overview Sheet and a Data Sheet
Worksheet “Data” has in Col B, Jan 1 thru Dec 31 with a dollar total at the end of each month.
Using the formula =SUM(B4:B34)
i.e.
=SUM(B4:B34) This is January the total line being B35
=SUM(B36:B64) This is February B65
=SUM(B66:B96) This is March B97 and so on. Each month is totaled
On Overview Sheet
I have columns labeled January through December
=SUM(Data!B35) This is the total for the data items for January
=SUM(Data!B65) This is the total for the data items for February
=SUM(Data!B97) This is the total for the data items for March
How can I fill in the correct formula for all twelve months without physically typing the new code formula in all of the 12 month cells

👍👍👌👌

How can I join this course? Is it free?

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

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

Hi Leila, 1st of all Tank you so much for sharing these priceless knowledges. can you make a session on Splitting data from on Master sheet to another multiple sheet as per sales country or department wise by VBA coding.

No matter what I do I can't get this to work at all very frustrating for something that should be simple

Amazing!! thank you!

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

Thank you for your vidoes.
i have a question, if i wann copy certain columns (not all columns) from one sheet to another sheet, how can we record the Macro. Thansk

How do I perform this for all active sheets, combine into 1 tab?