Sum array (or something) based on multiple criteria

[VBA-NOOB]

Hi,

Have a big problem - don't know If its possible to solve it with VBA. If the socialsec, date, fruit is same then save it into a temp or something sum quantity and print out as 1 line else different rows.

Have a sheet with following data:

SocialSec Date Fruit Quantity
12345 2015-02-02 Apple 5
12345 2015-02-02 Apple 3
11223 2015-02-01 Banana 1
11223 2015-02-01 Pear 1

Printout in Sheet2:

SocialSec Date Fruit Quantity
12345 2015-02-02 Apple 8
11223 2015-02-01 Banana 1
11223 2015-02-01 Pear 1

Is this possible to solve? Best way to solve it thru an array, or? Feels impossible with VBA.

Thanks for help!

[zbor]

Use Pivot table

[VBA-NOOB]

Thanks for the tips but I need to solve it with VBA - this will be a part of my script.

Use Pivot table

[zbor]

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 use the paperclip icon to open the upload window.

View Pic

[VBA-NOOB]

TEST WORKBOOK.xlsxThank you sir.
Will attach my workbook - sorry for the bad choice of color.

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 use the paperclip icon to open the upload window.

View Pic

[zbor]

don't be sorry for color but for example

Elaborate logic from:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Is SocialSec criteria?
is Date criteria?
Fruit is, I got that.

[VBA-NOOB]

LoL! I'm sorry for being unclear.
Criteras: SocialSec, Date and fruit .

Thnx in advanced!

don't be sorry for color but for example

Elaborate logic from:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Is SocialSec criteria?
is Date criteria?
Fruit is, I got that.

[zbor]

I assume that but in that case your After sheet is wrong.
Here, try this;

Please Login or Register  to view this content.

[VBA-NOOB]

Hi sir,

My after sheet its not wrong. Its two different dates on all 3 lines of the strawberry fruit. I will try this and see how it works - will reconnect to you

I assume that but in that case your After sheet is wrong.
Here, try this;

Please Login or Register  to view this content.

[VBA-NOOB]

I have try to run the script but nothing happens? I placed an message box at the end and its running all the way but no printlines in sheet2? Have I forget something?
Possible to get some comments in script? Try to read it but feels like the whole script is only based on column A wich is only 1 of 3 criteras or am I lost again?

I assume that but in that case your After sheet is wrong.
Here, try this;

Please Login or Register  to view this content.

[VBA-NOOB]

Sir, thank you so much!!! It works perfectly!!!!! So glad!
Possible to get som comments in the script so I can add/remove more criterias?

thank you!

I assume that but in that case your After sheet is wrong.
Here, try this;

Please Login or Register  to view this content.