Generate 2 or more tables from one by column Project

[bkostic]

Dear all,


I am trying to customize a little bit the template to my needs. Im confrated with following problem.


In my table tblActivities I am entering some data.

The table structure is as follows: Activity; Start date; Due Date; Project


Now I would like to distribute the records to separately project tables with this structure:


Table 1 for Project 1

Activities, Start date, Due date


Table 2 for project 2

Activities, start date, due date


How can I solve that without VBA?

 

[Luke M]

You could filter your main table into the 2 subset quickly using Advanced Filter.

http://www.contextures.com/xladvfilter01.html


No VB required.