Dear expert
I have list of Quarter and month. under Quarter there are multiple months nos like 1,2,3,5,12,24,36...etc so if pick Q1-13 I want list out only unique values of adjacent column of month
for example if Q1-15 month 1,3,12,24,36 coming 12 times in i want list out one time only.
find the attachment raw data is in mis sheet if possible work in vba help me out.
Last edited by breadwinner; 08-05-2016 at 03:17 AM. Reason: attachment
Code on Sheets "DBD" :
Code on Module1 :
Please Login or Register to view this content.
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
An alternative.
Thanks lot sir It works 100% sorry for annoying you i want one more requirement if possible help me out
fill the formula in range where ever header value
start cell F4 till end of month no f4=SUMIFS(MIS!$D:$D,MIS!$A:$A,$E$2,MIS!$B:$B,F$3,MIS!$C:$C,$E4)
find the attachment
You are welcome.
Please add the red line to existing code :
Please Login or Register to view this content.
Wow amazing it works sorry sir this is last requirement i just tried to add grand total of summary range from your code is it right
.Offset(1).Resize(.Column.Count - 1).Formula = "=SUM(F4:J4)" Please help on one line code sir thanks alot
This should do :
Please Login or Register to view this content.
Got it This Line makes beauty of table .Resize(, .Columns.Count + 1).EntireColumn.AutoFit. Thanks alot sir hats off to your brilliant code. Thread solved by Karedog
Last edited by breadwinner; 08-08-2016 at 02:17 AM. Reason: karedog
You are welcome. Thanks for marking the thread as solved.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks