Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

dynamic column range IN A TABLE

I have a fruit list, every week I want to choose from the list a different number of fruits, and the fruits I have chosen I have to put into my table titles in the middle of the table,evry time I select from this dropdown list , I want ta add a new column with the selected fruit name, and later i want to put in the right row the amuont of this specific fruit .But next week the list will be shorter or longer (and so is my table) and other fruits will choose. How do you do that in vba code?


Hi iz4il and welcome to the Forum.

Sorry but it looks like you have made no attempt to create VBA code to solve your own problem. It's not reasonable for you to specify your requirements and expect someone to create the code for you. That happens occasionally but generally we expect users to make some attemptĀ and ask questions when they get stuck. Suggest you try and come back/ edit your question to attach a revised file.
John_Ru (rep: 3677) Jul 18, '22 at 9:06 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login