I like your presentation good day take care and lots of thanks for your videos please upload all subjects marathon class theory you are the best beautiful teacher in the world
I use VBA a lot to speed up processes, I like to save them in the Personal Macro Workbook and add the macro to my Quick Access Toolbar so I can use them across multiple spreadsheets.
Hey @terri24601! You can build a macro extension which automatically opens source files and does the copy paste in between the source and the Excel file with the macro. Source file name/path could be set in a specific cell of the Excel easy to manage by folks not having any macro/VBA knowledge. Cheers
I don't know if it's just me, but I am not able to implement it successfully when the amount of data changes (I use my keyboard to select the data range)
I could’ve used this many years ago when I started out. Excellent video.
I like your presentation good day take care and lots of thanks for your videos please upload all subjects marathon class theory you are the best beautiful teacher in the world
I use VBA a lot to speed up processes, I like to save them in the Personal Macro Workbook and add the macro to my Quick Access Toolbar so I can use them across multiple spreadsheets.
I love your channel so much!! Thanks for all these tips on how to better use Excel
You're just awesome, thank you!
Superb way of explaining all the steps.❤
انت رائعة جدا ... شكرا لك ... عمل مفيد كثيرا
Great video. Thank you for sharing!
Thank you!!!!
Good and easy explaination
Love this. What’s the best way to get the new data into the macro enabled workbook each week? Is there something better than cut and paste?
Hey @terri24601!
You can build a macro extension which automatically opens source files and does the copy paste in between the source and the Excel file with the macro. Source file name/path could be set in a specific cell of the Excel easy to manage by folks not having any macro/VBA knowledge.
Cheers
Your voice ❤
Love you too much Madam
Better Video
Beautiful macros... like you ❤
Emma I love you ❤
Do you tutor online?
Excel macros are saved to personal.xlsm file so just need to enable dev mode for excel and to enable macro edit you need to unhide personal
Is the developer tab an add-in that needs to be added in 😅?
I don't know if it's just me, but I am not able to implement it successfully when the amount of data changes (I use my keyboard to select the data range)
What about a way that as soon as data is entered into say column A it automatically time stamps