troubleshooting Question

Excel 2013: How to pull data from one worksheet into another automatically

Avatar of stepnharp
stepnharp asked on
Microsoft Excel
9 Comments1 Solution171 ViewsLast Modified:
Hi,

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.
ASKER CERTIFIED SOLUTION
Koen
SDM Mobile

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros