Uploaded August 2021 | Updated November 2026, 2 days ago
In this video, we will see this VBA Code allows you to create Excel Table with the current sheet name using VBA. Usually, when we convert the data into Excel tables by default it is given with the "Table1" and later we need to manually rename the table name. With this VBA code, it will take the active sheet name and update it automatically when we convert it to Excel Table.
00:00 Intro
00:29 Understanding the Scenario
00:59 Using Macro Recorder
02:07 Editing the VBA Code
05:09 Copy the VBA Code from Website
05:33 Validation Error Table cannot overlap another table
06:00 Checking the code & Important Notes
07:10 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
Copy the VBA Code from the Website
excelexciting.com/convert-active-sheets-data-into-excel-table-by-sheet-name-with-vba
--------------------------------------------------------------
🌎 ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
youtu.be/UvrxmOrr8AQ
Excel Tip by the Excel Queen 👸🏻(Faraz & Leila)
youtu.be/6CEYKRIlppE
Two Best Excel Tricks by Excel Experts
youtu.be/ihVtnUDTCBM
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #ExcelVBA #ExcelMacro
In this video, we will see this VBA Code allows you to create Excel Table with the current sheet name using VBA. Usually, when we convert the data into Excel tables by default it is given with the "Table1" and later we need to manually rename the table name. With this VBA code, it will take the active sheet name and update it automatically when we convert it to Excel Table.
00:00 Intro
00:29 Understanding the Scenario
00:59 Using Macro Recorder
02:07 Editing the VBA Code
05:09 Copy the VBA Code from Website
05:33 Validation Error Table cannot overlap another table
06:00 Checking the code & Important Notes
07:10 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
Copy the VBA Code from the Website
excelexciting.com/convert-active-sheets-data-into-excel-table-by-sheet-name-with-vba
--------------------------------------------------------------
🌎 ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
youtu.be/UvrxmOrr8AQ
Excel Tip by the Excel Queen 👸🏻(Faraz & Leila)
youtu.be/6CEYKRIlppE
Two Best Excel Tricks by Excel Experts
youtu.be/ihVtnUDTCBM
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #ExcelVBA #ExcelMacro



![How to share your videos privately on Youtube
In this video, we see how to share your YouTube videos privately and share with others
🛒 Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
👍🏻Faraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
👥Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: The Talking Emoji If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
https://youtu.be/UvrxmOrr8AQ
Two Best Excel Tricks by Excel Experts
https://youtu.be/ihVtnUDTCBM
***********************************************************
#FarazShaikh #ExcelExciting #ProductivityHack #MadeWithCamtasia #YouTube How to share your videos privately on Youtube](https://i.ytimg.com/vi/x42RE3EgmTo/mqdefault.jpg)

![Excel Hash 2021 Challenge - Secret Formula for Sales Commission
In this Excel Hash Challenge 2021, we have some great ingredients to mashup and provide solutions. This is the third edition of Excel Hash Challenge and there are some great participants around the globe. Please feel to check other participants videos & dont forget to give a vote, like & subscribe.
Vote here:
http://bit.ly/ExcelVotingTool
00:00 Intro
00:39 ExcelHash 2021 Ingredients
01:12 Understanding the dataset
01:54 Power Query Custom Data Type
05:54 Cutout Person
06:50 Dynamic Arrays (Unique Function)
08:36 Even Function
10:00 Building Solution as Dashboard
14:24 End Screen
Check out other entries:
https://www.youtube.com/playlist?list=PLHrPHBbDHgT1OUshE6AFf5AJqJdhKhJh_
ExcelHash 2021 Ingredients
- A Cutout Person
- EVEN function
At least 2 from the following:
- LET function
- Dynamic Arrays
- Custom Data Type
- LAMBDA function
🛒 Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
👍🏻 Like Facebook Page :
https://www.facebook.com/ExcelExciting/
👥Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Custom functions in Power Query (and more) with Gašper Kamenšek
https://youtu.be/Qf_i45WinRo
How to Leave or Exit an Organization in Microsoft Teams
https://youtu.be/LNJb9Jj_PYI
Insert Data from Picture In Excel for Mac
https://www.youtube.com/watch?v=3-HgzQl7Khw
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://www.youtube.com/watch?v=c8d3xx8KVl8
***********************************************************
#Excel #ExcelHash #Excel2021 #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Excel Hash 2021 Challenge - Secret Formula for Sales Commission](https://i.ytimg.com/vi/xAlUPWRnfiQ/mqdefault.jpg)

![Create Dynamic Flowcharts by connecting EXCEL to VISIO
In this video, we will learn how to create dynamic flowcharts using Microsoft Excel connecting it to Microsoft Visio
VISIO Price Plan (Affiliate Link): https://microsoft.msafflnk.net/xWP31
🛒 Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
👍🏻Faraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
👥Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: The Talking Emoji If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Create Organizational & Business Flowcharts Linked to Excel
https://youtu.be/Cor1mixgotY
ON-VBA Solution Convert Number to Words In Microsoft Word [mac & windows]
https://youtu.be/W1Ghyp6Rla0
Trick to Create A Data Entry Table In Power Query for Excel
https://youtu.be/bHPrRbcw6f0
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
***********************************************************
#VISIO #EXCEL #ExcelExciting #ProductivityHack #FarazShaikh #MicrosoftCreators #ExcelTips #MadeWithCamtasia #Excel4Windows #ExcelTricks Create Dynamic Flowcharts by connecting EXCEL to VISIO](https://i.ytimg.com/vi/xfIPFiAxQcQ/mqdefault.jpg)


