How to merge rows that have similar location names

[aleanboy]

Hi All,

Please help me with this.

I have data of location & respective employee names in details sheet starting from row 6 till depends on day to day basis.
On clicking submit button, it should first sort by locations and then merge all the locations that are similar.
In short I need the final result as shown in sheet2,
but note: result should be in displayed details sheet only. That is merging & final output should be in details sheet only.
I have created Sheet2 just for your reference.

Kindly provide a macro code for this.

[MickG]

Try this:-
NB:- Generally, Merged cells and VB do not tend to go well together !!!!

Please Login or Register  to view this content.

Regards Mick

[aleanboy]

Hi Mick...
Your code still has some issues, when I click on submit sold on is getting repeated in sheet2

[aleanboy]

Hi Mick...
Your code still has some issues, when I click on submit "sold on" is getting repeated in sheet2 and also repeatative employee names should not be shown. What I mean is in the attached file
"Justin Miles" is working in same location but his name is listed twice on clicking submit his name should reflect only once and qty, cost values should be summed and displayed in final sheet. I have updated the macro code in excel & attached it for your reference.

please advise.

[MickG]

Can you show an example of the "Summed" values :- "Qty" ,"Cost" and "MTD Costs".
I'm not sure if they should be based on, "Person" or "Location".

[aleanboy]

Hi,

The summary I want is as shown in Sheet1.
So, on clicking submit button output should be as shown in sheet1.

Please advise

[jaslake]

@ aleanboy

This appears to be a duplicate Thread

http://www.excelforum.com/excel-prog...ils-sheet.html

[MickG]

If not solved !! , Try this:-

Please Login or Register  to view this content.

Regards Mick