I have a massive data table (tab1) which I am effectively trying to pivot without using a pivot table to tab 2.
In the data table I have lists of contractors with the hours the worked, charge rates etc.
On my summary page, I have the list of unique contractors and from here, I run sumif, averageif etc, formulae to get my summaries. my issue is, next week there would be say 400 new transactions, and say 5 new contractors. I want a way to automatically add those 5 new contractors to my contractor summary list.
Currently I run a vlookup on tab1 to see if there are any new contractors. I copy these to tab2 and then remove duplicates. is there a way I can get this done automatically because I have numerous summary sheets i.e. summary by country, client, consultant, period and so forth. I want a way to click a button or easily update my summary tabs so that any new contractors, consultants, countries etc are automatically pulled in without needing to search and manually copy these across.