Linking 100s of work books

[santidreamer]

We are building a hotel and want to break the costs into catergories:

Structure
Plumbing
Electrial

Then break them further

Cable
Lights
Fire Alarm

I could put all purchase orders in 1 workbook, which has the advantage of making summaries easy, but it will be 100s of work sheets long. Navigation and error finding will be hard.

Or I could put all purchase orders in separate workbooks making them much more managable, but harder to link.

The IT skills in my company are not good.

not sure which direction is best.

 

[Trevor G]

Consider using Access for something like this.

Easier to manage and manipulate data for reports etc.

 

[Smitty]

You might also check out Microsoft Project. I believe it's got some pretty heavy duty costing abilities.