dudewheresmyvba
New Member
- Joined
- Jul 6, 2017
- Messages
- 29
I have found a post that similar what I need to be done, but I do not know how to convert it to fit my purposes and data. I am not sure if I can link it here but ( How to combine values from multiple rows into a single row in Excel? - Super User ). What is different is that I am wanting to sum rows together so that the numerical value is accurate but my COUNT is not artificially high. Rows that are to be summed will have the same alphanumeric value in column B.
The matching rows that should act as the key is in column B, cells that should be summed are in column U, Y, AC, and AD.
I do not want the "extra" rows to be deleted or the values in them to be wiped though. This issue is giving me pain so help or other ideas to address this is appreciated. Also if you include some notes on how your code works that would be amazing.
The matching rows that should act as the key is in column B, cells that should be summed are in column U, Y, AC, and AD.
I do not want the "extra" rows to be deleted or the values in them to be wiped though. This issue is giving me pain so help or other ideas to address this is appreciated. Also if you include some notes on how your code works that would be amazing.