Basically i want to add items to 1 list based on columns from another list. so for example say i have 2 list, List 1 and List 2. List 1 has 5 colunms; Name, Age, id , Location, Manager. List 2 contains 3 colums; Name, Location, Manager.
What i want to do is when an item is added to list 1 i want to automatically add a new item to list 2. List 2 colunms should be autopopulated by the colunm values from list 1.
Anyone any ideas how i could acheive this i have tried using lookup values and i also tried using a workflow but cant seem to get it working properly. i am new to sharepoint.