Delete cells with duplicates

Hi,

I have this script below that deletes duplicates when the script starts it is looking at Col "H" The "H" part is working correctly however when it runs through col "G" it stops at row 6. Which means that col "G" ROW 5 and 6 are the same number.

Col "H" data can only be Monday,Tuesday,Wednesday,Thursday,Friday so the script will delete all duplicates of the above names

Col "G" data can only be the hours worked that day. so what I want is it to look at col H then delete all the duplicates in G.

So for example after the script runs col H looks like:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Col G should look like this.
8
8
8
8
8
Any Idea's

Please Login or Register  to view this content.

Thanks, Mike