Master Project Link Help

andreanovak

I am trying to create a master sheet with certain information from 20+ other sheets. Each row of the master sheet will be specific to one project with various dates that need to be tracked shown in each column.

 

Is there a way to make each cell automatically know which project to pull information from without linking each individual cell back to the project it is pulling info from? Like a way for each row to know what project to pull from and each column to know what cell in that specific project to pull data form?

 

Sorry if this is confusing. Thanks!

Andrée Starå

Hi Andrea,

I'm not sure I follow what you mean.

You don't need to link each individual cell because you can link the whole row/column or larger section.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

andreanovak

Andree,

 

Not sure if that is what I need to do. Basically I have 20+ sheets with a whole bunch of information in them. Each of those sheets is set up from a template with varying dates/information inputted for each project. I want to have 1 master sheet that pulls the main info out of each of the 20+ sheets. I'm trying to find a way to tell each cell where it needs to be pulling from without having to go in and link each cell indidvually. I want each row to know it is assigned a certain sheet/project and each column to know which cell in that project to be pulling from.

Andrée Starå

Andrea,

Are you creating the 20+ sheets continuously or are they already created?

andreanovak

They are already created

Andrée Starå

Ok. I think that the easiest solution is to cell link the sheets one by one.

How is the information structured on the sheets? Can you share the sheet or a screenshot?