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

First of all, I don't have SP Server installed, therefore I can't write a SP application Secondly, my only tool is SP Designer 2007 I have a Contact List SP list: Name, Email, ...other info, Department I'd like to create another list: Department, Count(*) and update it whenever List 1 is modified. Create a Group By view won't work as I want to have the list 2 as a Data Source on another site web part or maybe I'm wrong and it's possible to display a view (not list) on another site.

Site 1 List 1

John Smith.... Mechanical

James Brown....Procurement

Kevin Jones....Mechanical

Site 2

Data View Web Part

Mechanical 2

Procurement 1

Is that possible?

share|improve this question
add comment

Your Answer


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

Browse other questions tagged or ask your own question.