Excel 2013: How to pull data from one worksheet into another automatically
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.
If you create a name range (CTRL-F3, click new) and put this in there, where 12 is, that is the number of columns in the data sheet, you can change that number to how many columns you have. So instead of highlighting all the data, for the Vlookup, use the name range instead.
If you had a sample sheet I could try to set it up for you.