- 10
- 11 192
GG (ጂጂ) Info Tech Academy
United States
Приєднався 23 тра 2021
Welcome to GG (ጂጂ) Info Tech Academy,
Are you ready to master Microsoft Office and 365? Whether you’re a beginner or an intermediate, this channel is your ultimate destination for everything you need related to Word, Excel, Access, VBA coding, SharePoint, Lists, PowerApps, Power Automate, and more!
🔹 What We Offer:
- Clear and concise guides to help you navigate and utilize Microsoft Office and 365 products efficiently.
- Practical VBA coding in Microsoft Excel and Access to automate tasks and enhance your efficiency.
🔹 Why Subscribe?
- Pleas stay current with the latest features and updates from Microsoft technology solutions.
- Engaging Content we provide to you.
Hit that Subscribe button and turn on notifications so you never miss an update. Have a question or topic you’d like covered? Please drop us a comment. We would love hearing from you!
Are you ready to master Microsoft Office and 365? Whether you’re a beginner or an intermediate, this channel is your ultimate destination for everything you need related to Word, Excel, Access, VBA coding, SharePoint, Lists, PowerApps, Power Automate, and more!
🔹 What We Offer:
- Clear and concise guides to help you navigate and utilize Microsoft Office and 365 products efficiently.
- Practical VBA coding in Microsoft Excel and Access to automate tasks and enhance your efficiency.
🔹 Why Subscribe?
- Pleas stay current with the latest features and updates from Microsoft technology solutions.
- Engaging Content we provide to you.
Hit that Subscribe button and turn on notifications so you never miss an update. Have a question or topic you’d like covered? Please drop us a comment. We would love hearing from you!
Copy Data Between Any Two Sheets with Excel VBA | Assign Macro Tutorial
In this step-by-step tutorial, learn how to copy data between Excel sheets using VBA macros. Whether you're automating tasks or improving your workflow, this video will show you how to write a VBA macro to copy data from one worksheet to another and assign it to a button for easy use. Perfect for Excel beginners and anyone looking to enhance their Excel automation skills.
By the end of this video, you'll know how to:
• Write a VBA macro to copy data between sheets in Excel
• Assign a macro to a button for quick execution
• Automate repetitive tasks in Excel using VBA programming
Steps to follow:
1) Create two Sheets in Excel Spreadsheet, named Data and Backup.
2) Add Some samples of data in the "Data" sheet.
3) Open VBA editor using ALT + F11 or Click on Developer Tab and then Visual Basic.
4) Once the VBA editor opened, write the VBA code below:
Sub CopyData()
Sheets("Data"). Range ("A1:B6"). Copy
Destination: =Sheets("Backup"). Range ("A1")
5) Save the Excel Spreadsheet using Excel Macro -Enabled Workbook.
6) Create a command button and link this button to the CopyData Macro.
7) Click on the button to copy data from "Data" sheet to "Backup" sheet.
If you find this helpful, don’t forget to like, subscribe, and hit the notification bell for more Excel tips and VBA tutorials!
By the end of this video, you'll know how to:
• Write a VBA macro to copy data between sheets in Excel
• Assign a macro to a button for quick execution
• Automate repetitive tasks in Excel using VBA programming
Steps to follow:
1) Create two Sheets in Excel Spreadsheet, named Data and Backup.
2) Add Some samples of data in the "Data" sheet.
3) Open VBA editor using ALT + F11 or Click on Developer Tab and then Visual Basic.
4) Once the VBA editor opened, write the VBA code below:
Sub CopyData()
Sheets("Data"). Range ("A1:B6"). Copy
Destination: =Sheets("Backup"). Range ("A1")
5) Save the Excel Spreadsheet using Excel Macro -Enabled Workbook.
6) Create a command button and link this button to the CopyData Macro.
7) Click on the button to copy data from "Data" sheet to "Backup" sheet.
If you find this helpful, don’t forget to like, subscribe, and hit the notification bell for more Excel tips and VBA tutorials!
Переглядів: 4 300
Відео
Excel - VBA Message Display
Переглядів 11421 день тому
An Excel spreadsheet utilizing VBA code to display customizable messages and alerts. Steps to be followed: 1) Open an Excel Spreadsheet. 2) Open VBA editor using Alt F11. 3) Double-click "ThisWorkbook" listed under VBA Project. 4) Write your VBA Code. 5) Save the Workbook as Excel macro-enabled Workbook. 6) Close the Workbook and reopen it. Then, the message will be displayed.
Protect an Excel Spreadsheet with Password
Переглядів 120Місяць тому
Protecting your Excel Spreadsheet with Password adds an extra layer of security to your data.
Simple Interactive Calculator Part 2
Переглядів 2422 місяці тому
Learn how to create a simple and interactive calculator using HTML and JavaScript. In this video, we walk through the process of building a basic web-based calculator that can perform simple arithmetic operations like addition, subtraction, multiplication, and division. Perfect for beginners looking to practice their web development skills!
Simple Interactive Calculator Part 1
Переглядів 2392 місяці тому
Learn how to create a simple and interactive calculator using HTML and JavaScript. In this video, we walk through the process of building a basic web-based calculator that can perform simple arithmetic operations like addition, subtraction, multiplication, and division. Perfect for beginners looking to practice their web development skills!
Balance Transfer Credit Cards $$$ - Everything you need to know - Explained in Tigrigna (ትግርኛ).
Переглядів 2162 місяці тому
Benefits of Balance Transfer for Credit Cards explained in Tigrigna. How balance transfers work and how to use them effectively. Please Subscribe now ua-cam.com/channels/t3HkIU_KRTUL9y8XfKgXUw.html
Learn how to create, access data entry forms and remove duplicate entries in Excel.
Переглядів 1932 роки тому
In this video, you will be learning on how to easily create and access data entry forms in Excel. Also, learn how to remove duplicates in any Excel data sheet. This is the easiest way to create form in Excel and enter data quickly and accurately with no VBA or macros required.
Finding Mean, Standard Deviation, and Variance of sample data using formula in Excel VBA.
Переглядів 1,4 тис.3 роки тому
This video tutorial explains on how to use the mean, standard deviation, and variance formula to calculate sample data using Excel VBA. The formula for the mean, standard deviation and variance are also provided to support the explanation in VBA codes.
Assign Macro to a command Button in Excel.
Переглядів 3523 роки тому
In this video, I will show you on how to assign Macro to a command Button that run VBA codes in Excel.
Learn How to Create Student Grade Book Using Excel VBA - Super Easy!
Переглядів 4 тис.3 роки тому
In this video, I will walk you through the steps for creating simple student Gradebook using Excel VBA. Students are assigned letter grades based on a grading scale using "IF" Function.
🙏🏿🙏🏿🙏🏿🙏🏿
Thank you Akbir for your subscription!
🙏🏿🙏🏿🙏🏿
Thank you Akbir!
I wish I knew about this balance transfer before
A lot of people don't realize how useful balance transfers can be until they need them. Glad you found the video though! Hopefully, the info helps you in the future.
Super great tutorial
Thank you for your feedback!
Good for personal documents
Thank you
Good Job Dani
Thank you Robel
Thank you sharing
Glad you found it useful
Great for securing your data
I’m glad you like it. Thank you
Great for securing your data
Very educational!
Thank you Sami-p4n
Thank you for this video!
Glad it was helpful!
Nice one
Thanks for watching
Your subscription would mean the world to me! ua-cam.com/channels/t3HkIU_KRTUL9y8XfKgXUw.html
Your subscription would mean the world to me! ua-cam.com/channels/t3HkIU_KRTUL9y8XfKgXUw.html
Your subscription would mean the world to me! ua-cam.com/channels/t3HkIU_KRTUL9y8XfKgXUw.html
Your subscription would mean the world to me! ua-cam.com/channels/t3HkIU_KRTUL9y8XfKgXUw.html
Thank you!
You @Matiwos-p5f
Great going Dani…❤❤
Thank you so much Vidhu for your support and subscription!!!
The <h1> tag should be placed within the <body> section of an HTML document. However, I noticed that it was incorrectly positioned between the </head> and <body> tags, which is not the proper placement. Despite this, I'm curious how the browser still manages to render the incorrectly placed tag. I apologize for the confusion this has caused to you.
The <h1> tag should be placed within the <body> section of an HTML document. However, I noticed that it was incorrectly positioned between the </head> and <body> tags, which is not the proper placement. Despite this, I'm curious how the browser still manages to render the incorrectly placed tag. I apologize for the confusion this has caused to you.
I can’t even express my gratitude I passed my exams all Because of you. My professor was pleased. No rechecks just 100% much love
I am glad it was helpful. Thank you for your feedback!!!
it's simple and clear, ዳንኤል
Thank you so much for your feedback @pala_Bapak_Kau
Thanx Boss keep it up nice job❤❤
Thank you Masha for your comment!!!
Thank you for learning. 🥰
Thank you so much Winti for your complement!
Good job Dani!
Thank you Habtemariam
Very useful video!
Glad to know it is useful!
Thank you for sharing this with us Dani!
Thanks Habte!
Great content Dani!
Thanks Habte!
Welcome Daniel.
Thanks Ziye!
Way to go Dani. Great video, helpful resource.
Thank you so much Amare! Glad it was helpful!
dani arife newe
Thank You Dani!
Good Job Dani
Thank you so much Seghen Hawey!
Good job Daniye 👍👌
Dereje, thank you for your complement!
This is cool! I like it.
Thanks Selam!
So helpful. Good job.
Thanks Mussie for your feedback!
Hey this is great tip Daniel!!! 👍
Glad it was helpful!