Hello all,

I have a workbook with 3 worksheets. Each worksheet has a table of 10 numbers (Table 1, 2 and 3 for example.) I need to merge the two tables then filter them numerically once merged for just the top 10 results. I have managed to merge the two tables together but cannot then filter them numerically.

I only need the After speaking with a few people they recommended a macro to look through the two tables and add the top 10 highest values to an array then write the values into the new table. This seems like a good idea but Im no good at VBA so need help.

Thanks very much in advance