Hi folks,
I am new to vba coding and struggling with a simple task.
The requirement is that I have an excel document with two worksheets. One of the worksheet has just got a combo box and the other worksheet has data.
The data in worksheet contains columns out of which one column is Year.
I want the data sheet to be filtered based on the year chosen in combo box.
Will really appreciate if someone could help me.
Thanks
Preeti
Someones just asked this, use their post for help.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
It's impossible to get your range references from JPGs - much better to attach a workbook instead - but try something like:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Here is the document.
Really appreciate your help.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks