Thanks zelgar that worked perfectly, your one post was very helpfull😊
Skip I know what I needed for the particular job I was doing, I am new to the forum so apologies if I wasn't sure how to upload a helpfull data sheet.
Regards sbbunno
Hi Skip
This data is going to be used for an update into another system and will require the current formatting. i preserved the original data on another sheet.
Hi
I have been looking around but cannot find what i am looking for.
Column A = Work Order Number
Column B = Operations Number
column F = man hours
I need a macro that can identify the duplicates in column A and B, sum up the man hours into the first line and then delete the duplicate rows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.