Log In
Register
Home
June 26, 2016
Offline
Hello everyone, my name is Maurizio
And my problem is this:
On a sheet of excel from the cell (A3: D9) but I could go even further, I entered the codes "CAP" followed by the numbers put from time to time by hand (See Column (B))
Now my request is this: It would be possible using the VBA; Create a sort of filter that knows how to calculate the total sum of the amounts entered in the same Code (CAP) in such a way as to fill the Total.
All inserted in a separate ladder always on the same sheet.
As shown in my attachment, thank you
Greetings from Maurizio
VIP
Trusted Members
June 25, 2016
Offline
Hi Maurizio
Why do you want to use a macro to add the formula? Can't you just key in manually?
Are you trying to SUM or COUNT? What is the asterisk (*) for eg * A 0001?
Maybe you can explain a bit more clearly (with more scenarios and examples) what you are trying to achieve.
See if the attached helps.
Sunny
June 26, 2016
Offline
Hi SunnyKow
You are also right in saying that you do not understand well what I wanted to achieve; But maybe as always it was just a matter of Google Translation.
But do not worry about trying and trying again, I managed in the meantime to solve everything from me; Without using vba but simply the functions of excel.
Thanks anyway for your interest
Sincere greetings from A.Maurizio
June 26, 2016
Offline
Excuse me for SunnyKow
I only saw now that you had entered your file
That's fine, that's what I wanted to do from the beginning
Your Help and Stupendo Thank you really Gaius and see you soon
Some good old formulas entered manually can usually solve the problem.
