Hi,

I am working on a project now in which I have a excel database which contains results pulled from an online survey. The database contains a results tab and several tabs with automated analysis. As I receive new results I copy/paste the row into the results tab and the table updates itself. My problem is I am using a "Result ID" as a primary key for each result and when I add an additional row I have to go through the tabs and expand each table that has "Result ID" as a field by one (or however many new results were added). I would like to make a macro that automatically updates those specific tables as I add additional rows. Please help