quick fix visual basics macro - expert required

the attached file contains macros which we use for data processing. we have two bugs which need fixing: 1) the macros error if the excel file is above a certain number of rows. i want this fixing so that it will work for larger files. 2) one macro works by grouping data, and then merge the rows together, removing duplicate cell values, and inseting a comma seperated list of the [login to view URL] is a bug with this program and it maxes out when the group is too large. both fixes need to be fixed on my pc, via teamviewer. the winning bidder must have/download teamviewer and mst be free immediatley to fix the macro. this should not take more than 30 minutes to fix and as such the budget is £20