LinkBack URL
About LinkBacks
bcr 
Hi
1) Can we see your existing code
2) Where do you want the consolidated output to appear?
rylo
Hi
1) Can we see your existing code
2) Where do you want the consolidated output to appear?
rylo
Well, for some reason, now it sends my sorting results to the end of the sheet, but here is the coding.
Range("D3:D1000").Select Range("A3:d1000").Sort Key1:=Range("D3"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End Sub
What i am wanting is for it to sort based on the origin, and then combined like part numbers' quantites, and place the result starting at row 3.
Last edited by rylo; 06-18-2008 at 06:33 PM.
Hi
Time for an example workbook. The first sheet can show your raw data, and the second sheet shows how you want the output structured. Sorting the data in place is not going to cumulate duplicate items, just arrange them together. If you want to cumulate, then you will have to create a unique list somewhere, then bring in the cumulated totals. Maybe a pivot table???
rylo
I was trying to avoid having to have someone use a pivot table, but it looks like that is going to be the best bet.
Thank you for all of your time and help.
~BCR~
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks