Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

You definitly can do this with workflows.

Just create a list-workflow on List1 which creates a new Item on List2 with the given item values and set the workflow to "Start workflow automatically when an item is created".

All you need for this task is the SharePoint Designer.

If you do so, also consider the occurence of changes in List1 or List2. Check this link for how to synchronize 2 lists.

share|improve this answer
    
Cheers got it working using workflows thanks –  derek Oct 26 '12 at 12:59
    
For some reason I didn't see this the first time I looked to do this (being blind ftw?). Thansk! –  enderland Sep 5 '13 at 14:34
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.