I have a shipping report that the company I develop systems for uses daily.
Ive used a mod formula in Column N to detect duplicates in Column C:
And have used a similar formula in Column O to label each item as part of an "order number":
This has successfully separated these rows into groups that will be shipping together, based on similar names and has allowed me to use conditional formatting to identify the separate combo orders for the day.
The data that we get from the company we distribute for is always uniform, it includes the amount paid for each item (column K, labeled PAID) as well as the total amount paid including shipping (column L, labeled Order Total.
Unfortunately I need the total without shipping, which would be all of the PAID values that would be shipped together.
Currently I'm using a macro that totals the current selection and then writes the total value in the next open cell to the right of the selected cell:
In the end I would like to have a VBA macro that would produce a TOTAL PAID column (based on the sum of the individual PAID values of an order) so I wouldn't have to do it by hand, the solution is really just failing me right now though
An example spreadsheet is attached.
Thanks
PS: Its my first post, so please forgive me if i missed on some semantics
Bookmarks