At the same time, it looks for the value in A9 in whatever sheet it is looping through, in order to match that value to a column header in sheet 'Data' (and sets that column as HdrCol). It then looks to match the right 10 values in the cell with a date in the column P on sheet 'Data' (and sets that row as HdrRow). My current macro, as seen below, loops through all my sheets, except the ones specified not to loop through, then in each sheet it loops through each cell in the range W7:W200. The table has dates running down the first column (Column P), and a few names as headers. A little background, my sheet 'Data' consists of a table, which my macro is supposed to populate.