I have tried a formula to combine/sum these items together and was able to do it; however, my file is way too big for a formula to make this happen without crashing (besides it would be much easier). I was hoping someone could make this happen in a macro (please see sample data attached)? I appreciate your time.
Book1.xlsx
Last edited by AJJ; 02-06-2012 at 07:06 PM. Reason: Solved
Sorry about the clutter
Location Box Sku
102V 78075 141938
141938
141938
72498 141932
141932
141932
141932
141932
141932
141932
141932
141932
78721 133565
133565
133565
133565
133565
133565
103V 78115 141415
141415
141415
141420
141420
141420
141420
141420
141420
141420
141420
141420
Location Box Sku QTY
102V 78075 141938 3
72498 141932 9
78721 133565 6
103V 78115 141415 3
141420 9
Last edited by AJJ; 02-06-2012 at 05:56 PM. Reason: Clutter
hi AJJ, one of the options, please check attachment, press "Run", the data is supposed to be sorted (blocks are going one by one with the same value)
Last edited by watersev; 02-06-2012 at 06:45 PM.
YOU ARE THE MAN! Thank you, it works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks