VBA Macro to Filter with Input box, Split files, Convert into Excel Table and Sort

Hello,
Good day everyone. Hope you guys are doing great.

I am looking for a vba based solution for the subject mentioned tasks. (almost novice in vba)

I found this code (sheet attached) somewhere on the web, it works find but I need some modification and I hope you guys will help.


Modifications required:

1) Instead of this hard coded range, we need an input box to enter column name (eg: "A")

Please Login or Register  to view this content.

2) Before saving we need in each file, Convert the data into Excel Table and add a Total row and sum formula in column E (Table total row).


3) Sort Column E (Largest to smallest)

Any or all help is appreciated.

Regards,

Hi Leo,
Thanks for the help.

I am having error:
Screen shots attached.

at the following:

Please Login or Register  to view this content.

Regards,

Hi Leo,
It works like a magic

I will check this on complete file on Monday, and will give my feedback.

Really appreciate your help.
Blessing to you,

Khalid

Hi Leo,
Good day.

My colleagues are much happy with your solution.
Thakns for your help.

Just a follow up question:
Is it possible to add one more inputbox for the sorting?
I mean we can enter the column name in inputbox and it will sort all the files based on inputbox?

Appreciate if you could help on this too.

With regards,
Khalid

Hi Leo

Yes exactly, you have already helped for the fist inputbox, which is working great.
Need 2nd inputbox for sorting on columns before saving each file. 2nd inputbox can be any type of, e.g: A,B,C or table header name e.g: name, b.assigned etc. Whichever is possible.

I think A,B,C will be much easier for user.

Many thanks,
Khalid

Hi Leo,

That works great on the sample. I am sure it will work the same way on my actual file, I will test tomorrow and will let you know.

Many thanks and have a good day.

Regards,

Khalid

Hi Leo,

I have tried on my actual file and it works like a dream

Please accept my sincere gratitude for your help.

God bless you.

Regards,

Khalid