Hi Team
I preparing Report every month my Client Payments and Payment date (Latest payment) , this process i am doing it manually, this process sucks more time , i was tried "max" formula as well
its returns 0,
Could you anyone help me to simplify the process (using vba macro generate the report as expected)
Payment_Details
payment_details.jpg
Report
report_result.jpg
i've attached sample sheet,
Hi !
Why don't you use Excel BASICS ?!
Sort data on dates column in descending way, use an advanced filter on first column to get unique clients …
And if you really need a code, activate Macro recorder before to operate : you will get your own free code !
i have reproduced,
BUT a Pivot table would do the job , the only issue is
how do you define the MAX value for date and the value to return
you have multiple values for the same client and the same date
do you want to sum those
or are you simply basing they value on the last value in the list
see client7
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Try this for results starting "F1"
Regards Mick
Please Login or Register to view this content.
Try this !
PHP Code:Sub Macro1()
[F6].CurrentRegion.Clear
With Cells(1).CurrentRegion
.Sort Cells(1), xlAscending, Cells(2), , xlDescending, Cells(3), xlDescending, xlYes
.Columns(1).AdvancedFilter xlFilterInPlace, Unique:=True
.Copy [F6]
If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData
End With
End Sub
Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !
thank you very much , your code help me to get result as i expected
Thanks for the rep' !
Base code created using Macro recorder just with Excel basics …
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks