Hi All,
Trying to find a better way, looking for some help, here is some background and my queston.
  • My point of sale system exports data to excel.
  • I then have a list of the items sold with each row containg the name of the item and the quantity sold.
  • It does not combine sales but lists each sale so there are many rows that have the same item name on them with different quantities sold
  • I then sort the data to group all rows with the same item name together and then manually sum the quntities listed in those rows to get my total for that item for the month.
  • I then enter te sum of all the rows that are the same item into the top row and delete the others
Obviously thats a lot of manual clicking and manipulating, I'm hoping someone here can show me a better way.
The worksheets are always different each month so there is no consistency to the order or even which items will appear on any given month which complicates it more.
Thanks in advance for any help you can offer, even if it is only partial solutions, if it helps cut down on the work that is great.