I am using Excel 2013. I have a very simple .xls worksheet which records our vehicle inventory, it is over 1000+ records. The columns are:
Make; Model; Year; Licence_Num; State_Registered; Reg_Expiration
I want to pull data from the first worksheet into another worksheet automatically by using the State_Registered name. (all records have the normal abbreviations TX, NM, ect and are consistent). I have used Vlookup and the basic filtering, which works fine. But the total number of vehicles changes monthly, which makes trusting the data questionable.
When New Month Inventory list is completed. I would like to copy-and-paste the new inventory into the first worksheet and when I go to the corresponding state tab, the records for all State_Registered records will be updated automatically.
Any suggestions will be helpfully. Thanks for your assistance.