Hi Frndz,
i have yearly data of students i need to show data if i selected some Specific Month (Eg: Feb) then need to show only Fen Month Students data in Second sheet
Sheet1 Yearly data of student
Sheet2 Cell A1 Dropdown month's
Need to show data from Sheet1 on post Cell A1
when i will change the month (Sheet2 Cell A1)the data to change as per the month also the student name to be sorted alphabetic order.
ThankS
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Sheet1.pngSheet1.pngSheet2.png
please am unable to attach excel file please refer the attached images
Try this code in your Sheet2 Module:
Please Login or Register to view this content.
Last edited by xladept; 10-28-2017 at 02:52 PM.
Another variant, with "combobox" ... but ... I'm not "F.e.RN.an.D.e.Z" ("Hi Frndz") ...... maybe Rodrigo ...
thanks for help i have one more doubt if i need to avoid the column of Class and Month then where i need to be change the range selection
it would be a great support if can solve this
Thanks
Liju
You're welcome!
i need only fields Employee Name, Activity and Month, i have to avoid the column class
This should take care of that:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks